ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't view Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/127879-cant-view-workbook.html)

galantgirl79

Can't view Workbook
 
User opens excel workbook from network drive. Excel opens fine, but the
actual workbook is grayed out. User can still click on cells and cell
contents show in formula bar, but there is no grid or data just blank gray.
Happens on local machine and RDP. Excel 2003 all updates are applied.

Dave Peterson

Can't view Workbook
 
Try:
Window|Arrange|tiled
and resize the way you like it

galantgirl79 wrote:

User opens excel workbook from network drive. Excel opens fine, but the
actual workbook is grayed out. User can still click on cells and cell
contents show in formula bar, but there is no grid or data just blank gray.
Happens on local machine and RDP. Excel 2003 all updates are applied.


--

Dave Peterson

tabcourt

Can't view Workbook
 
Did you guys ever figure this one out? I've got the same problem and the
instructions below don't help. They just show a new blank worksheet with
gridlines, etc. and my grayed out worksheet side by side.

-Mark

"Dave Peterson" wrote:

Try:
Window|Arrange|tiled
and resize the way you like it

galantgirl79 wrote:

User opens excel workbook from network drive. Excel opens fine, but the
actual workbook is grayed out. User can still click on cells and cell
contents show in formula bar, but there is no grid or data just blank gray.
Happens on local machine and RDP. Excel 2003 all updates are applied.


--

Dave Peterson


Dave Peterson

Can't view Workbook
 
Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe one of these will work for you.

tabcourt wrote:

Did you guys ever figure this one out? I've got the same problem and the
instructions below don't help. They just show a new blank worksheet with
gridlines, etc. and my grayed out worksheet side by side.

-Mark

"Dave Peterson" wrote:

Try:
Window|Arrange|tiled
and resize the way you like it

galantgirl79 wrote:

User opens excel workbook from network drive. Excel opens fine, but the
actual workbook is grayed out. User can still click on cells and cell
contents show in formula bar, but there is no grid or data just blank gray.
Happens on local machine and RDP. Excel 2003 all updates are applied.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com