#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 661
Default linking error

Why will my destination file only update if the source file is open? If the
source file is closed, I get the error message: Unable to read file. Please
help!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default linking error

Some functions don't work on closed files.
There are usually alternate approaches available.

Post some of your formulas.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Paul" wrote in message
...
Why will my destination file only update if the source file is open? If the
source file is closed, I get the error message: Unable to read file. Please
help!


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
Linking Between Sheets and #Value! Error Melanie Excel Worksheet Functions 6 June 15th 07 02:30 PM
Sumif Linking to Another Workbook error #VALUE! drgka55 Excel Discussion (Misc queries) 3 July 27th 06 05:32 PM
Linking between workbooks and getting #REF error TangentMemory Excel Discussion (Misc queries) 0 November 10th 05 12:34 AM
Linking error Julie Quass Excel Worksheet Functions 4 October 18th 05 05:48 PM
#Value error when linking workbooks FOLALD Excel Worksheet Functions 1 September 13th 05 02:17 AM


All times are GMT +1. The time now is 09:21 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"