I have an excel file used by over 100 people. It contains about 10 tabs and
is opened and closed dozens of times per day on each machine. It is not a
shared file, each user has their own copy. All machines use Excel 2003.
OCCASIONALLY, and only on a FEW random machines, the file opens to a gray
screen. File Preview shows no data, the file does show an Excel tab on the
taskbar, and Excel reports "ready". Right clicking the taskbar tab shows
Minimize/Maximize options are grayed out. "Restore" simply enlarges or
contracts the gray Excel window. We have discovered a "workaround" of opening
a new blank workbook in excel. The grayed out file can then be maximized from
the taskbar and it functions perfectly. The blank workbook file can then be
closed without saving. The "grayed out file" can then be closed and saved.
When reopened, it will normally be fine until some random time in the future
when it opens as gray. Most users are very basic and this stops them dead in
their tracks, resulting in a support call. The "Ignore other applications"
referred to in other posts is not an issue as this happens randomly and the
balance of the time the file opens perfectly and all other Excel files open
and close perfectly......... This problem has occurred from local and
networked file storage locations, or if the file is opened from an email
attachment. Again 99% of the time the file opens and functions perfectly.