Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links
First of all, I have tried again and again to post into the misc group
but my message gets stuck on the end of an old message????? not at the top where I want it Anyway hello all, I use several linked files at work, I noticed the links hadn't updated properly in a few of the files, I opened a file and had to F2 a cell link and the correct numbers then were displayed. I noticed at the same time which must be connected that normally the path of the link will reduce to just the name when the source file is open. This wasn't happening the full path was still displayed when the source file was open. I made sure of the obvious things, like drive mappings still available and calculation set to automatic, I know I still have the mappings etc as I can open the source files no problem Any ideas Cheers David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links
Have you tried, from the main menu, Edit Links and press the Update Values
button? This doesn't explain your problem, but it may solve it for practical purposes. Keith " wrote: First of all, I have tried again and again to post into the misc group but my message gets stuck on the end of an old message????? not at the top where I want it Anyway hello all, I use several linked files at work, I noticed the links hadn't updated properly in a few of the files, I opened a file and had to F2 a cell link and the correct numbers then were displayed. I noticed at the same time which must be connected that normally the path of the link will reduce to just the name when the source file is open. This wasn't happening the full path was still displayed when the source file was open. I made sure of the obvious things, like drive mappings still available and calculation set to automatic, I know I still have the mappings etc as I can open the source files no problem Any ideas Cheers David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Relative Links becoming Absolute Links? | Excel Programming | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions |