Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link to table
I have a spreadsheet that links to several spreadsheets-- 1 for each month of
the year. These monthly speadsheets are not open when opening the single speadsheet. When the spreadsheet opens it asks to update the LINKS and I respond YES. Months Jan to Oct work fine, but when it tries to update the Nov and Dec links, it acts like it can't find the spreadsheets. I have to navigate to the network drive and reselect it. After doing some work in the spreadsheet, I save it. Yet again when it is opened, it still can't find these same spreadsheets. What tools can I use to debug the problem? Is there a way to see all the links in a spreadsheet? Or what other ideas does anyone have? THANKS, MEG |
#2
|
|||
|
|||
It sounds to me like your formulas aren't pointing to the correct
folders/filenames/sheetnames. Maybe you could open the workbook with all the links, but answer No to updating links. Then Edit|links to see where they point to. (and open windows explorer to verify that they exist where they should.) MEG wrote: I have a spreadsheet that links to several spreadsheets-- 1 for each month of the year. These monthly speadsheets are not open when opening the single speadsheet. When the spreadsheet opens it asks to update the LINKS and I respond YES. Months Jan to Oct work fine, but when it tries to update the Nov and Dec links, it acts like it can't find the spreadsheets. I have to navigate to the network drive and reselect it. After doing some work in the spreadsheet, I save it. Yet again when it is opened, it still can't find these same spreadsheets. What tools can I use to debug the problem? Is there a way to see all the links in a spreadsheet? Or what other ideas does anyone have? THANKS, MEG -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |