Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Peter Vousden
 
Posts: n/a
Default Creating links to a worksheet on a network.

Hi,

Can link to a file in any directory or on the network by manually finding it
and pressing OK, but have loads to do so was hoping to write the links
myself. Now I know that the following works for a directory on my hard disk:

=sum('c:\data\[13.xls]Sheet1'!e17:e19)

but how is this changed for \\Server\c\dir1\subdir2[file.xls]!e3.....??

Have tried a mass of options but no joy.... Also want to break up the
strings and concatenate them so that can just change 1 variable per worksheet
- that still works, right??

Many thanks in advance.....
Peter
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
Creating links to a worksheet on a network. Peter Vousden Excel Worksheet Functions 0 April 7th 05 01:17 AM
Worksheet links Debbie Excel Worksheet Functions 0 January 26th 05 10:01 PM
Worksheet links Bruce the Battler Excel Worksheet Functions 5 December 6th 04 05:49 AM
Creating new worksheet from existing ddpen Excel Discussion (Misc queries) 2 December 1st 04 11:35 PM
Creating Links A Psychologist in Alberta Excel Worksheet Functions 0 November 5th 04 03:15 AM


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