Changing 1 sheet and all other are changed too

[mary29]

I have in excel some information set up and each month is on a seperate sheet within that document. I have changed one sheet and saved it and now when I go and look at the other sheets they have all been changed to that same one I changed originally.

I have no idea what I did to cause this

Can you help

Mary

 

[SkipVought]

Mary,

What changed, the sheet name or the data in the sheet?

Does anyone else have access to your workbook?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

If it is the data that has changed, you may have inadvertantly selected ALL the sheets whilst entering data into the one sheet. The effect of doing this is that the data gets entered on ALL the sheets selected at the time - this may have caused your overwrite problem....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[bluedragon2]

Also,

If you had formulas like:

=sheet1!A1

on sheet 1 and you copied the whole sheet to a new sheet, the reference to sheet 1 will not change. So any information you add to sheet 1 will be reflected on the pasted sheet.



Blue

If I wasn't Blue, I would just be a Dragon...