Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an xls file with 5 sheets in it. If I write ="something" in B2 in sheet1 all sheets 2-5 also is changed in B2.

This happened after several problems with 2003 vs. 2007 versions of office. Now we all have the 2007 office, but the problem persists.

Does any one know some weird setting that would do that?

share|improve this question
add comment

2 Answers

It may be that you have all the sheets selected before you type in the cell. For example, if I want my name on every sheet in a workbook, I can select all the sheets, then type my name in a cell and hit Enter. The name will appear in that cell on every sheet. The same would be true of the formula you're typing.

share|improve this answer
add comment

Could it be that all cells in sheets 2-5 have a formula with a reference to the equivalent cell on the 1st sheet?

For example, your cell B2 on sheet 2 would contain the formula =Sheet1!B2.

share|improve this answer
    
If i dont write anything in sheet1 other data exist in all the other sheets –  svrist Jan 7 '10 at 7:42
1  
Do you have a macro running in the workbook that would do this? –  Snark Jan 7 '10 at 7:55
    
Ill see if I can find one... –  svrist Jan 7 '10 at 9:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.