I have a user that is VERY excel heavy. She has hundres of spreadsheets that she uses on a daily basis. Recentely she called to say that when she opens certain files in Excel, she has multiple instances open. By this, I mean that the file name 'sheet.xls' shows up as 'sheet.xls:1' in Excel. If you click Window at the top to see the list of windows to switch to, you will see 'sheet.xls:1' and 'sheet.xls:2' and even sometimes a third 'sheet.xls:3'. There are only certain files that are this way. The workaround that I've found is to create a new spreadsheet and copy the data from one to the other.
Here's the details:
The files open this way on all OSes (NT, XP, 2K, 98, etc)
The files open this way on all versions of Excel (97, 2K, XP)
Is there something that my user is doing to save these files in a way that they open twice? The workaround that I found worked initially, but now I'm getting 4 or 5 a week that need to be changed so there HAS to be some reason why these start opening like this. I found no helpfull information on Microsoft's forums, but of course I have no clue what key words to search for.
Has anyone else out there run across this?
Thanks,
.oO( FLiP )Oo.
Kenneth Henrichs
Here's the details:
The files open this way on all OSes (NT, XP, 2K, 98, etc)
The files open this way on all versions of Excel (97, 2K, XP)
Is there something that my user is doing to save these files in a way that they open twice? The workaround that I found worked initially, but now I'm getting 4 or 5 a week that need to be changed so there HAS to be some reason why these start opening like this. I found no helpfull information on Microsoft's forums, but of course I have no clue what key words to search for.
Has anyone else out there run across this?
Thanks,
.oO( FLiP )Oo.
Kenneth Henrichs