Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Blank page in excell 2010


22 Feb 2011   #1
sam49

Windows 7 Professional 64 Bit
 
 
Blank page in excell 2010

Hi guys can i ask a question please
I am using Microsoft office 2010 and for some reason now when i open an Excel spreadsheet and enter data, then when i close Excel, behind the one i was using is another blank Excel worksheet its just blank with no cells or anthing like that just a blank page.

Every thing works ok its just that i have to close two worksheets every time i use Excel

Does anyone know what is happening


My System SpecsSystem Spec
.

22 Feb 2011   #2
mitchell65

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

If you open Excel then Click File then Open. Then navigate to your file and open it the original new file will stay in the background. If you then close the sheet you are working on that will show the new one with a message "Do you want to save Book 1". If on the other hand you first navigate to your file then double click it Excel will open with just your file showing. If your new worksheet opens with no grid lines etc then try this:
With Excel open, go to Tools, then Options then click the View Tag. If the Gridlines box is not checked then check it. Now when you open Excel the grid lines will show.
My System SpecsSystem Spec
22 Feb 2011   #3
sam49

Windows 7 Professional 64 Bit
 
 

[QUOTE=With Excel open, go to Tools, then Options then click the View Tag. If the Gridlines box is not checked then check it. Now when you open Excel the grid lines will show.[/QUOTE]

Hi thanks for the tip but where is the tool option when you say go to tools with excell open.

What i usually do to open s excel file is go to the file i need to open and double click and the file opens no problem.
But then when i have edited the file and saved it and then close the file, thats when i get a ghost like workbook still open i can then close this one and all is ok but my question is when i double click a excell file why does two excell open two workbooks
My System SpecsSystem Spec
.


22 Feb 2011   #4
mitchell65

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by sam49 View Post
Hi thanks for the tip but where is the tool option when you say go to tools with excell open.
This explains it better than I can, why MS made it so complex is beyond me:
What happened to the Options command on the Tools menu? - Excel - Microsoft Office
My System SpecsSystem Spec
23 Feb 2011   #5
sam49

Windows 7 Professional 64 Bit
 
 

Hi guys thanks for the info,

But it think my excel open has a problem when i double click on a excel file why does it open two worksheets one with cells on it and one without cells
My System SpecsSystem Spec
23 Feb 2011   #6
mitchell65

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Does sound as if you have a problem with the actual program. Perhaps going to Control Panel and Programs and Features, highlight the MS Office 10 and click "Change" this should offer you a repair option. Might be worth a try!
My System SpecsSystem Spec
23 Feb 2011   #7
sam49

Windows 7 Professional 64 Bit
 
 

Ok Thanks i will give that a try
My System SpecsSystem Spec
23 Feb 2011   #8
Irene

Windows 7 Home Premium 64bit
 
 

How are you closing excel?

I suspect that you are using the lower of the X's (highlighted in yellow below) on the top right of your workbook. This will close only the current workbook, leaving the Excel program open for further use. The X (highlighted in red) will close the program and workbook. See the first illustration below.

Alternatively, you can close the program and worksheet by the method in the second illustration below.




Attached Images
  
My System SpecsSystem Spec
01 Jun 2011   #9
Ric

Win7
 
 

The blank sheet is caused by the PERSONAL.XLSB page. If you record and save a macro, Excel creates the PERSONAL file and opens it every time you open Excel. If you delete that file, you won't see the blank page anymore.
My System SpecsSystem Spec
02 Jun 2011   #10
sam49

Windows 7 Professional 64 Bit
 
 

Hi Ric
Thanks for the info. but i dont think i have a marco in the excel sheet. and i dont know what a Personal.xlsb page is or how to get rid of it.
The only thung i can say is the file was password protected, and now i have remover the password the blank page is not there anymore.

Thanks again
My System SpecsSystem Spec
Reply

 Blank page in excell 2010




Thread Tools



Similar help and support threads for2: Blank page in excell 2010
Thread Forum
Solved click new tab and it comes up blank page rather than first home page Browsers & Mail
Chrome does not work, no web page opens. Opens as a blank page. Browsers & Mail
Blank web page. How do I fix? Browsers & Mail
Solved Outlook 2010 emails being printed with blank pages between each page Microsoft Office
Blank Page Browsers & Mail
RWW and the dreaded blank page Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:22 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App