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 a problem where a colleague is editting a spreadsheet I provided in 2003 workbook format. When he is editing in Excel 2007, he is inserting a row on one sheet in the workbook. This is fine but the same new row gets inserted into all the other sheets. He has saved teh sheet in 2007 format before this problem occurred. I don't have the issue when I open it (and it gets converted into 2003) but I don't have 2007 to test it. Ive got someone else to try with 2007 an dthey can't re-produce it either.

Anyone have any ideas?

share|improve this question

2 Answers 2

Looks as though ungrouping the sheets might help (try clicking on one of the sheet name tabs that is not emboldened).

share|improve this answer

Things to try:

  1. Watch what your colleague does to make this happen. I guarantee it's not 'just magick'
  2. Make sure macros are disabled. This is so specific, I wonder if a macro is getting run without their knowledge.

If afyter trying these you still can't figure out what's going on, you might try posting the file - perhaps someone can diagnose it.

share|improve this answer

Your Answer

 
discard

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