Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Workbook links

I have a workbook that links to several others for daily data reports. When
I link a cell to the data workbook merged cell I get a #VALUE error in the
cell. The link reads ='[0227 Company 3.xls]Day'!$J$5:$J$6. If I delete the
":$J$6 " portion of the link it works fine. How can I fix this? It's taking
twice as long to set up my links when I have to remove that portion for each
hour of each day. Prior to updating to 2007 I didn't have this problem.
HELP?!?!?
 
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
My workbook links are not updating (its 30,000 KB size workbook). rselena Excel Discussion (Misc queries) 1 August 14th 06 09:14 PM
workbook links Pat Excel Discussion (Misc queries) 0 April 6th 06 05:26 PM
Workbook Links pavlai Excel Worksheet Functions 1 March 14th 06 03:44 PM
Links to other workbook Lolly Excel Discussion (Misc queries) 3 November 17th 05 01:10 AM
Workbook Links Jim Excel Worksheet Functions 3 June 16th 05 06:31 AM


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