Multiple worksheets opening.

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am running Office 97 on Windows 2000 and XP. When I
choose an Excel file to open the pop up informs me that
the file is already open and asks if either I would like
to make a copy or informs me that I cannot open two files
with the same name even though they may be in separate
folders. As far as I can tell there is no other file open!
Addiitionally, I have noticed that when I create links
between files that are open. Some links, rather than
reflecting the currently open file, refer to another file
in the My Documents folder. Sort of like there is more
than one My Documents - a parallel universe if you will.
This is getting frustrating. HELP!
 
Any chance you have buttons with macros assigned to them
on those files? If that's the case, look for changes in
the assigned macro names; Excel has a funny way of
inserting full paths before the file name on its own! For
instance, if you have a button with an assigned macro from
personal.xls, it will try to re-open personal.xls and then
tell you it's already open...
Nikos Y. (nyannaco at in dot gr)
 
Back
Top