Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I enable automatic updates of links between spreadsheets?

I have a series of spreadsheets that were created in Excel 2003 where data is
shared between the spreadsheets and they are linked together. Now that I
have upgraded to Excel 2007 and saved the spreadsheets as xlsx, I receive a
message "Security Warning Automated updates of links has been disabled." and
the information is no longer being updated between the spreadsheets as there
were before the upgrade. Even if I select the option to Enable the content,
they next time I open the spreadsheets the message reappears and I am unable
to update the information. I tried to recreate the scenario using
spreadsheets created in 2007 and the message does not appear. I can not
afford to recreate these spreadsheets so I need to find a way to fix this.
Does anyone have any thoughts?
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
Automatic updates of links between files €“ Excel 2007 Mary Ann Links and Linking in Excel 8 April 4th 23 10:52 AM
Automatic Updates paulw Excel Discussion (Misc queries) 0 September 22nd 09 02:42 PM
Prompt user on automatic updates for Workbook Links Rob Moore Excel Discussion (Misc queries) 0 February 10th 09 02:43 PM
Automatic updates PMach Excel Discussion (Misc queries) 0 May 30th 08 08:31 PM
AUTOMATIC UPDATES Jillian Excel Worksheet Functions 0 January 6th 06 08:43 PM


All times are GMT +1. The time now is 06:43 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"