Coworker wanted me to double check her work and when I open the spreadsheet it comes up blank (just gray) not even showing the columns and rows. But looking at full screen I can see it. All other excel spreadsheets are fine.
2006-12-19 01:56:20 · 8 answers · asked by tdc01slm 1 in Computers & Internet ➔ Software
There are alot of tricks in Excel to do this, I just need you to check these one after another
1- Go to (Window > Unhide) and see if there are items shown in the dialog that appears
2- Go to (Tools > Options > Window options) and make sure you select (Row and column headers, gridlines, horizontal scroll bar, vertical scroll bar)
3- got to (Format > Sheet > Unhide) and check the hidden sheets
PS: If excel asked for password, then the file is protected, you will need it
Enjoy my profile, I am the VBAXLMan
2006-12-23 00:37:31 · answer #1 · answered by Anonymous · 1⤊ 0⤋
Blank Excel Spreadsheet
2016-12-12 12:19:14 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Excel Opens Blank
2016-10-04 13:56:49 · answer #3 · answered by daughenbaugh 4 · 0⤊ 0⤋
This Site Might Help You.
RE:
Excel Spreadsheet opens up blank?
Coworker wanted me to double check her work and when I open the spreadsheet it comes up blank (just gray) not even showing the columns and rows. But looking at full screen I can see it. All other excel spreadsheets are fine.
2015-08-19 19:32:19 · answer #4 · answered by Anonymous · 0⤊ 0⤋
If the screen opens with a grey background one of 3 things generally is the culprit:
1) Window Updating was somehow set to False. you can enter the VBA IDE and in the Immediate Window type: Application.ScreenUpdating = True
2) There is another process of Excel running in the background. hit Ctrl-Alt-Del to bring up the task manager. Click on the Processes tab and search for some hidden Excel's. This can occur if there is another application that calls a shell of the Excel app.
3) The workbook is hidden. If the user makes changes in their workbook, accidentally hides the workbook, and close and saves the workbook, it will remain hidden on open. Check Windows Unhide to see if the workbook is available.
2006-12-19 16:35:16 · answer #5 · answered by Cerdle 2 · 3⤊ 0⤋
Did you open the file on her PC, or did she send you the file?
Do you both have the same version of Excel?
Did she save the file as filetype: MS Excel?
If she saved the file to an Excel file, I can't think of a reason why you should not be able to open it.
Interested in learning how you solve this problem.
2006-12-19 03:23:25 · answer #6 · answered by TheHumbleOne 7 · 0⤊ 0⤋
Same problem. I checked View - Full Screen and the worksheet was there but I couldn t work on it. Then I selected View - New Window. That worked and I saved the file with another name. I noticed after I closed that file/window that I had a formula left on the blank screen - one that I had not put there. I deleted it and then closed the window.
2015-04-29 03:28:18 · answer #7 · answered by Anonymous · 1⤊ 0⤋
With Excel closed, click the start button and in the search box, type
excel /unregserver
Close Excel.
Then, again, click start and type
excel /regserver
This should restore defaults.
2015-08-18 00:58:40 · answer #8 · answered by Gulraiz 1 · 0⤊ 0⤋
In my case whenever i create a new workbook ,it opens blank(no rows and Coloums), i have to manually add rows and coloums to it ,please help me
2014-07-12 23:10:48 · answer #9 · answered by Anonymous · 0⤊ 0⤋
this is a virus..please disable macros and run a popular virus scan on your machine
2006-12-19 15:22:36 · answer #10 · answered by thautheman 1 · 0⤊ 1⤋