something in registry forcing update links in spreadsheet

jenki91 · Apr 9th, 2002, 11:28 AM

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 ]

jenki91 · Apr 9th, 2002, 02:54 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 11:28 AM	#1
jenki91 New Member Join Date: Apr 2002 Posts: 2	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 ]

Apr 9th, 2002, 02:54 PM	#2
jenki91 New Member Join Date: Apr 2002 Posts: 2	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.