Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Micha³ S
 
Posts: n/a
Default update links - problem

Hi
I have big problem with update links in excel file
When I'm opening excel file I click button "don't update links" (I need
'old data') but I still get fields with "#ARG!" Why ? and how can I resolve
this problem.
Thanks for help


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I bet #ARG! translates to #Ref! in English.

If I'm correct:

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



"Micha³ S" wrote:

Hi
I have big problem with update links in excel file
When I'm opening excel file I click button "don't update links" (I need
'old data') but I still get fields with "#ARG!" Why ? and how can I resolve
this problem.
Thanks for help


--

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
Update Automatic Links Not Working in 2003 cydkil Excel Discussion (Misc queries) 2 February 15th 05 03:35 PM
Update Links - Problem Metallo Links and Linking in Excel 2 January 25th 05 04:42 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM
How to update multiple links in multiple spreadsheets followin mo. Andy Excel Worksheet Functions 0 January 20th 05 04:51 PM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


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

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

About Us

"It's about Microsoft Excel"