Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 31st 05, 12:49 AM
GNSBoy
 
Posts: n/a
Default auto file path update when excel sheet moved to another directory.

Hello,
I've been working on a huge excel file for a while and I'm trying to make
it easier to use. My problem is that when it is moved from the template
folder to a working folder the formulas referencing a file in the template
folder have their path changed in the formula and have to have the links
updated. Since the file is protected it's impossible for the users to chance
the source. It's wierd because it will still pull information, but if
information is changed in the external data file the updated doesn't get
ported over.

I need some like the $ command to stop Excel from changing the drive path.
I'd rather have no drive path and have all the reference files open, then the
working directory file is opened. Or statically assign the proper path for
the reference file sitting in the template folder.

Any help, without having to use VB scriping would be apprciated. Thanks


  #2   Report Post  
Old August 31st 05, 07:46 PM
GNSBoy
 
Posts: n/a
Default



"GNSBoy" wrote:

Hello,
I've been working on a huge excel file for a while and I'm trying to make
it easier to use. My problem is that when it is moved from the template
folder to a working folder the formulas referencing a file in the template
folder have their path changed in the formula and have to have the links
updated. Since the file is protected it's impossible for the users to chance
the source. It's wierd because it will still pull information, but if
information is changed in the external data file the updated doesn't get
ported over.

I need some like the $ command to stop Excel from changing the drive path.
I'd rather have no drive path and have all the reference files open, then the
working directory file is opened. Or statically assign the proper path for
the reference file sitting in the template folder.

Any help, without having to use VB scriping would be apprciated. Thanks

='N:\ABC\AnotherDirectory\Main Site\Light\[PARS Template.xls]NARS'!$D$6

I want the path to stay in some cases and in others be the directoy where
the file was opened. The above path actually shouldn't be in front of the
file name because I want it to look at the open file that exists in the
directory. Other links point to a file in a fixed directory and I want to
make the path in front of the file static. EXCEL keeps updating the external
data links!!!! I want it to stop.

Thanks


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
Updating excel sheet with selected data from another sheet in the same file gsnivas Excel Worksheet Functions 1 August 4th 05 09:55 AM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
How to change the Excel Title Bar to show the full file path na... lmilkey8855 Excel Discussion (Misc queries) 2 January 6th 05 03:08 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 10:30 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017