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
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.
[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
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
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
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!
Ok Thanks i will give that a try
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.
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.
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
Quote