LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 191
Default Excel 2003 - Update or Don't Update Links Problem

Firstly, apologies if this question is not quite appropriate for this
discussion group but it seemed the nearest suitable one.

Secondly, this excel problem. I have a spreadsheet which contains links. It
is often emailed from one user to others for reviewing. They would normally
click "Don't Update" so as to review the previously linked informations.
However, it appears that unlike Excel 2002, when you open this spreadsheet
with Excel 2003 and get presented with the Update or Don't Update links
option, it doesn't matter which option you choose, Excel 2003 always tries to
update the links which leaves you with a sheet full of #N/A's rather than the
information previously contained within the sheet. Doing the same process on
a machine with Excel 2002 (i.e. pressing the Don't Update option) leaves you
with all the previously known information left in the spreadsheet rather than
the #N/A's.

I was wondering if anyone could shed any light on this as its a little
annoying for the users i support as we are in an office with a mix of Excel
2002 and 2003.
 
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 Links in Excel 2003 PAX_BFM Excel Discussion (Misc queries) 0 March 11th 08 03:01 PM
Avoid Update Links dialog in Excel 2003 Ian Chappel Links and Linking in Excel 3 June 29th 07 01:11 PM
Excel 2003 remote links update sherband Excel Discussion (Misc queries) 0 February 22nd 07 08:09 PM
Excel 2003 remote links update sherband Excel Discussion (Misc queries) 0 February 22nd 07 08:05 PM
Manual Update of Links in Excel 2003 pete_sa Links and Linking in Excel 2 January 29th 07 10:27 AM


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

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

About Us

"It's about Microsoft Excel"