MS EXCEL FILE OPENING ISSUE

Problem - unable to see any file when opening in excel

Solution - when we open a file in excel , sometimes file remain hidden and does not show anything in excel window
To view the file, Go to --> -->
and to hide the same again --> Hide


click below to more help on the topics

Momory error in excel files due to large in Size of files

Momory error in excel files due to large in Size of files.

Application - Microsoft excel 2000, XP, 2003

Solution - It is a well known bug in Excel - when you delete data is doesn't change the page dimensions and remember the cells are empty. All you have to do is

highlight the first empty column and hold down Shift+Ctrl and press the right arrow. Now goto Edit->Delete. Now highlight the first empty row, hold down Ctrl+Shift and press the down arrow. Now Edit->Delete again. Now press Ctrl+Home. Now save your workbook. This should clear the sheets, and you wil have kept your print area.