+ Reply to Thread
Results 1 to 2 of 2

About file paths

  1. #1
    Registered User
    Join Date
    06-06-2017
    Location
    Illinois
    MS-Off Ver
    Excel 2016
    Posts
    25

    About file paths

    I have a spreadsheet made up that references cells from other spreadsheets. When it's just on my computer, it's fine. However, if I want to send the sheets over to a different computer, I then have to spend time going through the sheet and getting rid of the file path from every cell that references a cell on another spreadsheet.

    What I'm wondering is, is there a way to have excel *not* add in the file path and just keep the reference to the other sheet?

    Some examples for clarity:

    What I want the formula to look like when I transfer the files to another computer:
    =GETPIVOTDATA("Count of StockNumber",'[Current Inventory Safe Version.xlsx]SQL'!$B$7,"Designation","N")
    What the formula looks like whenever I transfer the files to another computer:
    =GETPIVOTDATA("Count of StockNumber",'C:\blahblahfilepath\[Current Inventory Safe Version.xlsx]SQL'!$B$7,"Designation","N")

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: About file paths

    Try using INDIRECT()
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove file paths
    By basho924 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-18-2015, 06:57 AM
  2. Linked File Paths Change When File is Moved
    By belewfripp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-06-2013, 12:18 PM
  3. [SOLVED] Dynamic file paths. HELP!
    By christhweatt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2013, 04:22 PM
  4. Export To Inf file & Zip the Files from the given file paths picking every 10 rows
    By vivekhalder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 03:59 AM
  5. Need help with vlookup file paths!
    By LangerXXV in forum Excel General
    Replies: 2
    Last Post: 04-17-2012, 11:56 PM
  6. [SOLVED] excel file paths
    By Jane in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 12:05 PM
  7. [SOLVED] file paths
    By hr in forum Excel General
    Replies: 0
    Last Post: 12-07-2005, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1