MXL5: "Not Enough Available Memory" Using Find File

• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, when you click Find File on the File menu to search for a specific file or type of file, you receive the following error message:

   There is not enough available memory to complete that operation

CAUSE

This behavior occurs if you are running Microsoft Excel for the Power Macintosh on an Apple Power Macintosh, and you use the Find File dialog box to copy a file to a different directory, and you then delete the file that you copied.

For example, if you copy the file TEMP.XLS to a new Untitled Folder using the Find File dialog box, and you then use the Find File dialog box to delete the file TEMP.XLS, the next time you click Find File on the File menu, you receive the "out of memory" error message.

Note that this behavior does not occur if you copy and delete the file in different Find File sessions; that is, if you close Find File after you copy the file, and then use Find File again to delete the file.

WORKAROUND

To work around this problem, when you receive this error message, delete the Search Results 00 file, located in the 'System Folder:Preferences: Microsoft Find File' folder, and then click Find File on the File menu in Microsoft Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. The problem was corrected in Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about Searching For Workbooks, choose the Search button in MS Excel Help and type:

   finding, workbooks