Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Linked spreadsheets failing to recognised that the linked file is

Hi, I have an unusual problem using Excel 2007. I have a file that is linked
to another file on a network.

I'll call them master file which is linked to the linkfile.

Sometimes, when I open linked file and then open masterfile and then edit
links in masterfile and check status it says "ok" instead of "file open" and
the valuies are not the latest numbers.

I have checked to make sure that there is not another copy of the file
somewhere.

If I then change source and relink the file everything works file.

Alternatively, if I close the linked file and then re-open it using the
recently used file list (to make sure I am opening the same file that I have
just closed) then check status and it is now saying file open and the values
are now updated.

Has anyone come across this before and anyone got any ideas as to what is
happening please?
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
Linked Spreadsheets Mike Lang[_2_] New Users to Excel 4 March 26th 09 04:34 AM
Linked spreadsheets Pammy Excel Discussion (Misc queries) 1 September 4th 08 04:30 PM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
In a linked calculation how do I lose the '0' in the linked file? Anita Excel Worksheet Functions 2 February 3rd 06 01:54 PM
linked spreadsheets Mifty New Users to Excel 6 September 10th 05 12:10 PM


All times are GMT +1. The time now is 07:35 PM.

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

About Us

"It's about Microsoft Excel"