Levels of indirection

  • Thread starter Thread starter Jim-Bob
  • Start date Start date
J

Jim-Bob

When attempting to save a file, I get an error msg
stating "Excel cannot complete this task with available
resources. Choose less data or close other
applications." A Microsoft KB article states that the
cause is more than 20 levels of indirection.
While the file in question is quite large and uses a
vlookup function several thousand times, there are only 3
named ranges in the workbook and I do not understand
where the problem is. Can anyone help/explain?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top