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
click below to more help on the topics
Monday, April 27, 2009
MS EXCEL FILE OPENING ISSUE
Saturday, April 25, 2009
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.
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
Subscribe to:
Posts (Atom)