View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default Excel cannot complete this task with available resources

Thanks for sharing.

By the way, "thousands of defined names"? May I ask what project that is
and how you manage them all?

Matthew Pfluger

"Robin Hammond" wrote:

Quick one for the archives.

Error message launching Excel 03 as shown in the title to this post.

Lots of complex solutions about nested named ranges and pivot tables on msdn
that I messsed with for a while when this started appearing while working on
a workbook with thousands of defined names.

The actual solution was a corrupted toolbar. So, search for the excel11.xlb
file and delete it. Problem solved.

Hope this helps someone in the future.

--
Robin Hammond
www.enhanceddatasystems.com