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
No comments:
Post a Comment