Id like to hear if anyone else has seen this anomaly. A colleague had this
happen. Ive not been able to recreate the problem with a new file. This
deals with Excel 2007.

My colleague created an Excel file. He emailed the file around his group
for input. When the file came back, he saved the file under a different name
in the same folder as the original. When he opened the modified file, Excel
would invoke normally but the window was blank. The frame and the ribbon
were fine, but no content. (I dont mean that a blank worksheet appeared. I
mean that no worksheet appeared. The body of the Excel window was just a
blank blue space with no lines or anything.) The original file would still
open OK.

Now heres the weird part. In the original file, you can click the maximize
button for the *worksheet* and thus make the worksheet a self-contained
window that floats inside the larger Excel window (as opposed to setting the
worksheet to its maximum setting, which fills the entire Excel window). The
original file had the worksheet set to this €œfloating€� state. If I maximized
the worksheet in the *original* file to fill the entire Excel window, then
opened the *modified* file, the contents would appear. But if I closed both
files, then set the worksheet in the original file to €œfloat,€� then opened
the modified file, the modified file comes up blank.

So I have a workaround but not an explanation.

Does that make sense? Does anyone know why?

You are suffering from a common problem in xl2007 that lots of people have
complained about. The workbook is open, just not visible.

One way to see it is to click on the Office button and start to open another
workbook, but then just dismiss the dialog. You may see your workbook open
after this. (Ctrl-O, then escape may work???)

Currently, there isn't a fix--just workarounds.

=========
I've seen some posts that suggest that turning on the solver addin (or any
addin) may remove the problem. I've never experienced the problem, so I never
tested if this was a solution.

kmewing wrote:

Id like to hear if anyone else has seen this anomaly. A colleague had this
happen. Ive not been able to recreate the problem with a new file. This
deals with Excel 2007.

My colleague created an Excel file. He emailed the file around his group
for input. When the file came back, he saved the file under a different name
in the same folder as the original. When he opened the modified file, Excel
would invoke normally but the window was blank. The frame and the ribbon
were fine, but no content. (I dont mean that a blank worksheet appeared. I
mean that no worksheet appeared. The body of the Excel window was just a
blank blue space with no lines or anything.) The original file would still
open OK.

Now heres the weird part. In the original file, you can click the maximize
button for the *worksheet* and thus make the worksheet a self-contained
window that floats inside the larger Excel window (as opposed to setting the
worksheet to its maximum setting, which fills the entire Excel window). The
original file had the worksheet set to this €œfloating€� state. If I maximized
the worksheet in the *original* file to fill the entire Excel window, then
opened the *modified* file, the contents would appear. But if I closed both
files, then set the worksheet in the original file to €œfloat,€� then opened
the modified file, the modified file comes up blank.

So I have a workaround but not an explanation.

Does that make sense? Does anyone know why?

--

Dave Peterson