Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2014, 07:31 AM
Doug Needham Doug Needham is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2013
Novice
Hidden Excel
 
Join Date: Nov 2014
Posts: 20
Doug Needham is on a distinguished road
Default Hidden Excel

When I open Excel files, they are completely blank. There are no row or column headers, and I don't see any Workbook tabs at the bottom of the screen. But I know the data is there because when I click on various areas of the blank screen, I can see information in the formula bar. The only solution I've come up with is to select View, Arrange All, and then select "Ok" under the Arrange Windows screen. My data miraculously appears, and everything works fine thereafter.



What causes my data to be "invisible" to begin with, and is there a better solution for this problem?

Thanks
Reply With Quote
  #2  
Old 11-06-2014, 11:16 PM
thetraininglady thetraininglady is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

can you upload a screen shot of how the screen looks when you first open the file?
Reply With Quote
  #3  
Old 11-07-2014, 04:54 AM
Doug Needham Doug Needham is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2013
Novice
Hidden Excel
 
Join Date: Nov 2014
Posts: 20
Doug Needham is on a distinguished road
Default

Here ya go.....just a whole lot of "snow".
Attached Images
File Type: jpg Screen Capture.jpg (70.7 KB, 16 views)
Reply With Quote
  #4  
Old 11-07-2014, 08:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Not sure about 2013 but try File - Options - Advanced - Under Display options for this workbook check everything and the same for Display options for this worksheet

Also check if any macros are active ( ALt+F11)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 11-07-2014, 08:49 AM
Doug Needham Doug Needham is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2013
Novice
Hidden Excel
 
Join Date: Nov 2014
Posts: 20
Doug Needham is on a distinguished road
Default

I tried changing the Display options, but that wasn't it. And there are no macros active.

I did a little experiment:

Scenario 1: I launch Excel and open Spreadsheet A. It's blank (my current problem).
Scenario 2: I launch Excel and open a blank spreadsheet. THEN I open Spreadsheet A, and it's now visible and working fine.

Does this help shed some light on the situation?

Thanks for your help!
Reply With Quote
  #6  
Old 11-07-2014, 04:46 PM
whatsup whatsup is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

Try: Save your file under new name when it's showing correctly. Close excel completely, afterwards open the new file.

Cheers
Reply With Quote
  #7  
Old 11-07-2014, 08:13 PM
Doug Needham Doug Needham is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2013
Novice
Hidden Excel
 
Join Date: Nov 2014
Posts: 20
Doug Needham is on a distinguished road
Default

That seems to have worked. Any idea what caused the problem in the first place?
Reply With Quote
  #8  
Old 11-08-2014, 05:18 AM
whatsup whatsup is offline Hidden Excel Windows 7 64bit Hidden Excel Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

As Pecoflyer said earlier, you will have to check with Display options and related themes. Obviously with saving the workbook when shown correctly you also saved another setting and the "error" was gone.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hidden Excel Word linking to Excel (hidden Excel) Doug Needham Word 5 11-04-2014 09:20 PM
Hidden calendar tuts73 Outlook 0 08-08-2014 02:31 AM
Hidden Excel VBA to keep hidden rows hidden when filtering tectonicseer Excel Programming 1 07-27-2014 11:54 AM
Hidden Excel How can I create hidden cell in Excel? itsolexpert Excel 2 05-15-2012 09:59 AM
Hidden Excel Hidden style applied over already-hidden text. christie Word 1 08-17-2011 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft