Excel documents open in invisible window

[Joanna]

I'm hoping someone can help with this problem.

I run Excel 2001 on a PowerMac G4, running 10.3.5. I have specific
Excel files that, when I open them, I get the opening "ding", but the
window is not visible. If I go to the Window menu and select New
Window, it will appear, but it has a colon and number afterward
("filename.xls : 2), because I now have the same document open in two
different windows. I worry that that could lead to corruption, and
bottom line, this shouldn't be happening anyway. It only happens on
certain files, and I cannot for the life of me figure out what's
different about those than others that work just fine. For example,
this morning, I had a file e-mailed to me. Ths file worked fine. I
wanted to preserve it as it was sent to me, but I also wanted to have
a version that I could adapt for my own purposes. So I did a Save As
and worked with it for a while. Eventually I closed it, and when I
went to open it again later, I had the "invisible window" problem. The
original file, as it was e-mailed to me is still fine. I've done a
Save As three different times with that original file (using different
names each time), and each time the new file has this problem the next
time I try to open it.

I saw a post from 2002 about this problem and the only posted answer
said maybe the file was saved as an Add-In, but that is not the case
here; I checked.

Any ideas would be most appreciated.

Thank you,
Joanna Beyer

 

[Bob Greenblatt]

I'm hoping someone can help with this problem.

I run Excel 2001 on a PowerMac G4, running 10.3.5. I have specific
Excel files that, when I open them, I get the opening "ding", but the
window is not visible. If I go to the Window menu and select New
Window, it will appear, but it has a colon and number afterward
("filename.xls : 2), because I now have the same document open in two
different windows. I worry that that could lead to corruption, and
bottom line, this shouldn't be happening anyway. It only happens on
certain files, and I cannot for the life of me figure out what's
different about those than others that work just fine. For example,
this morning, I had a file e-mailed to me. Ths file worked fine. I
wanted to preserve it as it was sent to me, but I also wanted to have
a version that I could adapt for my own purposes. So I did a Save As
and worked with it for a while. Eventually I closed it, and when I
went to open it again later, I had the "invisible window" problem. The
original file, as it was e-mailed to me is still fine. I've done a
Save As three different times with that original file (using different
names each time), and each time the new file has this problem the next
time I try to open it.

I saw a post from 2002 about this problem and the only posted answer
said maybe the file was saved as an Add-In, but that is not the case
here; I checked.

Any ideas would be most appreciated.

Thank you,
Joanna Beyer

You are right, it should not be happening. However, I do not think that
multiple windows is likely to lead to corruption. This may happen when your
machine (or the one creating the file has multiple screens, or when one
screen is much larger than the other. Instead of creating another window,
try this:

With the file open select window-arrange, and check windows of active
workbook. This should redraw the window at full size (assuming there is only
one window for the document) on the current screen. It will also reset the
default window location, so that when it is saved or reopened it should
remain OK.

I am assuming that there are no macros that may be moving or resizing the
window, but this may also be causing your problem.