Excel 2007 : duplicating data

**lesray** · 01-27-2011, 01:41 PM

Hi, I am new so bear with me, i don't know what ive done but , When i enter data into 3 cells in my current worksheet it duplicates it into every workbook i have , ? what have i done wrong

**NBVC** · 01-27-2011, 01:52 PM

Perhaps you have multiple sheets selected.

Right-click on any tab and see if there is an option to Ungroup sheets.

**lesray** · 01-27-2011, 02:43 PM

Would multiple sheets not just affect the one document ,? because this is affecting all my Excel workbooks. But thanks for the info, i will try tomorrow when i get back to work

cheers Ray

**NBVC** · 01-27-2011, 03:01 PM

It doesn't affect all documents... I can't picture what you are saying is happening.. try closing all down and retry.. something ain't right if you type in one workbook and all workbooks are affected... unless those other workbooks have formulas directly pointing to the cell(s) you are typing in.

**lesray** · 01-27-2011, 04:51 PM

I'll let you know better tomorrow when i have time to see if your suggestion works ,this problem arose late on today at work and i didn't have a lot of time to troubleshoot it .but i'll let you know what's up properly when i get back to work.

**lesray** · 01-28-2011, 05:03 PM

Hi, I have to say thank you for your response you were spot on, and when i whent into work today it was up and running verry quickly thanks to you

Cheers Ray