 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / May 2007Error when updating links
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 ....  SignatureThanks and have a good day Ruth 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 >I have a number of workbooks that manage resources for projects - > [quoted text clipped - 13 lines] > 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 .... Hi Bob - Thanks for responding ... no macros in any of the workbooks that are linked and Excel 2003 (SP2) SignatureThanks and have a good day Ruth > Ruth, does the file contain macros? Do the linked to files contain macros? > What version of Excel? [quoted text clipped - 21 lines] > > 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 .... Hi Bob - any more thoughts on this? Please ...? SignatureThanks and have a good day Ruth > Ruth, does the file contain macros? Do the linked to files contain macros? > What version of Excel? [quoted text clipped - 21 lines] > > 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 .... Ruth, one thing you might try to narrow down the problem: For each worksheet in your workbook, copy it to a new workbook, and save as test1, test2, etc. Then close Excel and re-open Excel. Then open a new workbook and see if the problem occurs. Close the workbook and open another, .... This may narrow it down to a particular worksheet. One other thought: It may be a defined name that is a link to another workbook. Before doing the above, press CTL-F3 and review each range name by selecting it and seeing where it is linked. If it is a linked name and you do not need, delete it. I suspect this is the cause. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel > Hi Bob - any more thoughts on this? Please ...? > [quoted text clipped - 29 lines] >> > need >> > them to do so as the 'Team' managers are not good with Excel and .... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.