Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

You must log in to answer this question.