K
kmewing
I’d like to hear if anyone else has seen this anomaly. A colleague had this
happen. I’ve 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 don’t 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 here’s 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?
happen. I’ve 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 don’t 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 here’s 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?