excel sheet opens two versions at once

  keef66 15:48 24 Apr 2008
Locked

One of my colleagues appears to have a haunted version of excel, or at least he keeps sending me the same spreadsheet with an unusual feature.

Whenever I open it, it opens 2 versions of itself, filename.xls:1 and filename.xls:2. They appear identical.

Any ideas??

  Simsy 16:03 24 Apr 2008

to see if it has any macros. Perhaps there is one that is making a duplicate.

Can you create a new xls file yourself... save it , close it and reopen it and see if the same thing happens. This will tie it down to either the specific file or your installation of Excel.

Good luck!

Regards,

Simsy

  VoG II 16:14 24 Apr 2008

With filename2.xls showing click the Close button (not the red X, the X below in. Save and close the file. The next time you open it there should only be one instance.

  Onizuka 16:15 24 Apr 2008

I had this same problem about seven years ago with a colleague whose knowledge of Excel was zero. I can’t now recall the solution but as far as I can remember it had something to do with the way he was saving and closing the spreadsheet. I’m sorry not to be more helpful but it may give you a lead. I’m sure that VOG™ will come up with the goods.

  Onizuka 16:17 24 Apr 2008

VoG™ (sorry for the VOG™) - I should have waited another couple of minutes!

  keef66 16:25 24 Apr 2008

My version of Excel is fine; I can open old files and create new ones without this happening. I can also open Excel files sent by other people.

baffling thing is we've all just had new laptops with identical builds / software versions etc.

I'll check out the macro possibility.

  keef66 16:29 24 Apr 2008

That seems to have done the trick. Many thanks; it was driving me bonkers!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?