Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 11th 05, 04:49 PM
Jim Bud
 
Posts: n/a
Default Automatic links in Excel 2003

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie

  #2   Report Post  
Old January 12th 05, 01:13 AM
Dave Peterson
 
Posts: n/a
Default

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

Jim Bud wrote:

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie


--

Dave Peterson
  #3   Report Post  
Old January 12th 05, 03:39 PM
Jim Bud
 
Posts: n/a
Default

When I select "Don't Update" at the prompt still every time I open the
spreadsheet I get the "Update"/"Don't Update" prompt. So I did the registry
tweak and still get the prompt.

"Dave Peterson" wrote:

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

Jim Bud wrote:

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie


--

Dave Peterson

  #4   Report Post  
Old January 13th 05, 12:42 AM
Dave Peterson
 
Posts: n/a
Default

The registry tweak wasn't to get rid of the prompt. It was to keep the values
from turning to #Name? errors.

There's an option that you can use to tell excel to always update, but don't
ask.
Tools|Options|edit tab
uncheck "ask to update automatic links"

The links will be updated, but no prompt.

=====
There's a workbook level setting (added in xl2002) that you can use:
Edit|links|startup prompt

You can specify how the links should be handled at start up.

===
If the user specifies that they want to decide (via tools|options|edit), then
excel uses that setting.

Jim Bud wrote:

When I select "Don't Update" at the prompt still every time I open the
spreadsheet I get the "Update"/"Don't Update" prompt. So I did the registry
tweak and still get the prompt.

"Dave Peterson" wrote:

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

Jim Bud wrote:

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Old January 13th 05, 04:57 PM
Jim Bud
 
Posts: n/a
Default

Got it all straightened out, thank you so much for your help Dave, excellent!
Jim

"Dave Peterson" wrote:

The registry tweak wasn't to get rid of the prompt. It was to keep the values
from turning to #Name? errors.

There's an option that you can use to tell excel to always update, but don't
ask.
Tools|Options|edit tab
uncheck "ask to update automatic links"

The links will be updated, but no prompt.

=====
There's a workbook level setting (added in xl2002) that you can use:
Edit|links|startup prompt

You can specify how the links should be handled at start up.

===
If the user specifies that they want to decide (via tools|options|edit), then
excel uses that setting.

Jim Bud wrote:

When I select "Don't Update" at the prompt still every time I open the
spreadsheet I get the "Update"/"Don't Update" prompt. So I did the registry
tweak and still get the prompt.

"Dave Peterson" wrote:

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

Jim Bud wrote:

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie

--

Dave Peterson


--

Dave Peterson



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 03:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 07:39 PM


All times are GMT +1. The time now is 08:08 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017