#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow opening links between workbooks with links created in 2003 Russell Excel Discussion (Misc queries) 0 December 14th 09 02:59 PM
Update links box gives Continue or Edit Links dialog KarenF Excel Discussion (Misc queries) 0 May 18th 07 01:17 PM
Edit Links: Changing links on a protected worksheet Halibut68 Excel Discussion (Misc queries) 0 April 28th 06 11:03 AM
Relative Links becoming Absolute Links? GB Excel Programming 0 October 3rd 05 07:05 PM
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe Excel Worksheet Functions 1 September 29th 05 10:33 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"