Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Stephane
 
Posts: n/a
Default Save External Link Values

how to bypass by breaking the reference into multiple
smaller references to save internal values, is there another way to do it


"Charles Williams" wrote:

If its on Excel saves the values it has read from the external links with
the workbook that contains the links. This enables Excel to recalculate the
workbook without going back to the external file. I recommend leaving it ON,
but you could try turning it off and seeing how that works for you.

The not enough memory message is caused by too many external links (max is
16000 in a single reference: bypass by breaking the reference into multiple
smaller references)

see http://support.microsoft.com/?kbid=214342


regards
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com

"Hargrove" wrote in message
...
What exactly is Save External Link Values, and is it necessary for linked

files? I keep getting a message that says 'Not enough memory'....'unable to
save external link values'. Before I turned it off, I'd like to know what
I'm doing to the workbook. The help files don't seem to have anything on
it, or it's listed in some obscure way.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 02:04 AM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 09:49 PM
Missing "Save" and "Save As" functions EMSchon Excel Discussion (Misc queries) 2 December 27th 04 09:01 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 01:18 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"