 |
 | 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 / New Users / July 2006Update links to closed spreadsheet
I have an excel spreadsheet with formulas linked to data in anothe spreadsheet. The spreadsheet with the source data is not opened. Whe I press the Update Link button, the cells with the formulas linked t the closed spreadsheet returns a #VALUE# indicator. I have to open th source spreadsheet so that the Update Link will return the correct data Why doesn't Excel extract the data from the source spreadsheet when i is closed too many links could exist write a macro to open the related spreadsheet when the firs spreadsheet is opened. once the links have been updated it can clos the related spreadshee Am I supposed to include the source workbook reference within quotatio marks or without the quotation marks with quotes. make sure you have the full path in the first instance, an make sure you have the .xls in the second instance |
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.