ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Available Resources warning in Excel 2003 (https://www.excelbanter.com/new-users-excel/50265-available-resources-warning-excel-2003-a.html)

Othello

Available Resources warning in Excel 2003
 
Hello:
I am not exactly a new user, but new to Excel 2003, and I am finding that
operations that did not create a problem for me in the past are now
apparently troublesome.

In a not very large worksheet (less than 2000 rows, 30 columns, data only
until I add formulas) I add a column and put in a vlookup to grab a related
cell value from another workbook. The target range is in a larger book,
maybe 50000 rows, 2 or 3 columns of formulas, but nothing very powerful.

In Excel 2002 I don't remember ever having a problem, even with Word and
Outlook open, and maybe 3 other workbooks open at the same time, and often
with 4 or 5 colums populated by lookups, but now even without any other
applications open and only the two involved workbooks, I get the "cannot
complete with available resources" notice whenever Autorecover tries to run
or I try to save, with the followup warning that external links were not
saved.

The file is saved fine, and the lookups still work, but the warning messages
are a drag.

Any suggestions?
Thanks,
Othello



All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com