Hi,
I have 157 pivot tables that using 5 data files all the same file. I have a problem when I try to refresh the tables , I receive a message saying that I don't have engouh resources and I need to change the range, but I don't want to change the range or file. Is there a way you can free the memory after refreshing the pivot table.
Thank you
It depends on how large your PT source range and updating 157 pivots in one shot will take the whole system process to complete the task.
Save the file in .xlsb (Binary) format and check...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Anaipos,
Did you resolve your Memory Issue? Did SixSense' response assist you? I may be able to assist you however, I would like to know how you got on before I waste my time.
Take a look at another of my posts here;
http://www.excelforum.com/showthread...t=#post4404497
(Excel 32 Bit Vs 64 Bit on x64 Bit machine (Processor) and VBA)
Does this sound like your problem?
Currently nursing my baby boy who refuses to sleep!
H.
--If You Can't Measure It, You Can't Manage It--
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks