Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: external link update trouble

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Problem:

    Workbook A with charts has links to workbook B and will only update when both files are open. This is fine when local people are trying to view from network, when workbook A is emailed and parties do not have access to workbook B how do I send workbook A out so update is not necessary and #value error is not shown?

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could ask the recipients to set their calculation options (under Tools/ Options) to Manual and uncheck 'Recalculate before save'. Obviously they will not be able to F9 without losing everything to the #Value!

    Alternativly paste/special/ values into a new workbook, then there's no chance of the error.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you.

    The manual option works great.

    What I noticed is, if I save the file before emailing with the manual update option, things are all good and the end user didnt have to do anything but open the file...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •