Graham wrote to ask about a nagging problem he has with one particular Excel workbook. This workbook contains seven worksheets, one for each month, January through July. The worksheets contain quite a few formulas, and a graph is inserted in each worksheet. The first six graphs were created just fine, but whenever Graham tries to create the graph on the seventh sheet, he gets an "out of memory" error.
Chances are good that you aren't actually running out of memory, but are somehow running out of resources. The end result, however, is the same--Excel doesn't have what it needs to continue with the operation.
This situation seems to be a known problem with Excel 97, and Microsoft has addressed it in Knowledge Base article 168650:
http://support.microsoft.com/kb/168650
If this doesn't solve the problem, it could be that the workbook itself is corrupted in some manner. The only way to determine if this is the cause is to recreate the workbook, from scratch (no copying and pasting), and see if the problem goes away.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2732) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Need to clear out a large amount of information saved on the Clipboard? All you need to do is to replace it with a small ...
Discover MoreWant to cancel whatever menu command you started to use in Excel? The normal method is by pressing Esc, but this is not ...
Discover MoreOne of the great features of Excel is that it allows you to use named ranges. These can make your formulas much easier to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments