Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with links not working correctly in spreadsheet
Hi
We have a range of links in spreadsheets that are not working correctly. Below is an example of a link, that is exactly the same, displayed in two ways. =-'\\sydfp03\finance\FP&A\P&L\[BUDGET P&L VALUES.xls]Mgt 08'!$AO$55 =-'G:\FP&A\P&L\[BUDGET P&L VALUES.xls]Mgt 08'!$AO$55 When a linked spreadsheet is opened by clicking the cell that is referenced, for example, the first way, it will see that the spreadsheet is open, and update accordingly. However, if there is a link that appears in the second format, it does not see that that file is open, nor will it update. This works in both cases, i.e the linked spreadsheet is opened via the second format, link that appears in the first format will not be seen to be open, or update. If we create 2 fresh workbooks, link to the same cell in the 2 different manners, the problem is replicated so isn't spreadsheet, network drive, or any thing else, specific... Any help would be greatly appreciated! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Links - Problem | Links and Linking in Excel | |||
Spreadsheet not opening correctly | Excel Discussion (Misc queries) | |||
Problem Working with Named Ranges | Excel Discussion (Misc queries) | |||
Spreadsheet attachment problem | Excel Discussion (Misc queries) | |||
Baffling problem with links | Excel Worksheet Functions |