View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Error when updating links

Ruth, does the file contain macros? Do the linked to files contain macros?
What version of Excel?

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RWilliams" wrote in message
...
I have a number of workbooks that manage resources for projects -

There is a 'Master' workbook, that provides information about the status
of
the projects, to the 'Team' workbooks, and information from the 'Team'
workbooks update the day to day activities of the resources.

The Startup prompt for the 'Team' workbooks are set to 'Don't display the
alert and update links'
but when I open these, I am getting the Warning message - 'This workbook
contains links to other data sources' -
I select 'Update' and get the mesage 'This workbook contains one or more
links that cannot be updated' -
I select 'Edit links' and these update with no problem

Any suggestions as to why the links are not updating automatically? I need
them to do so as the 'Team' managers are not good with Excel and ....
--
Thanks and have a good day

Ruth