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

Thread: something in registry forcing update links in spreadsheet

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

    Default

    i have a spreadsheet with external links. when i open it as user 1 it asks whether i want to update. when i open as user 2, it opens trying to update the links. i can't save the worksheet with "update remote references" unchecked. any ideas on how to fix. when i replace ntuser.dat for user 1 with ntuser.dat for user 2, problem goes away. (not a valid fix for me.)

    [ This Message was edited by: jenki91 on 2002-04-09 12:43 ]

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

    Default

    I fixed this by deleting the following registry keys [current user/software/microsoft/office/9.0/Excel/options "Option";"Option 5";"Option 6";"Option 95"]
    Don't know why it worked, but it did.

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
  •