![]() |
Too much data to save a workbook
I am using Excel 2003. I have linked my working workbook (A) with another
workbook (B) containing a lookuptable consisting of 11 900 lines and 7 columns. I am using a combobox with a range called AreaList in (B). Then the index number generated by selecting an item in the dropdown list, is used as a lookupvalue by another cell in Workbook (A) to determine a corresponding value from the lookuptable in (B). When trying to save Workbook (A), I am receiving an error message "Excel cannot complete this task with available resources. Choose less data or close othe applications". The only application open at this point in time is Excel. Is the Workbook (B) to which the combobox is linked with a lookup formula using a lookuptable in (B) too big (11 900 X 7)? -- Tobie Hanekom |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com