+ Reply to Thread
Results 1 to 2 of 2

Formulas contain PATH info after copy/paste

  1. #1
    Forum Contributor
    Join Date
    04-12-2006
    Location
    Morgan Hill CA
    Posts
    107

    Formulas contain PATH info after copy/paste

    I have to cut & paste certain sheets in my project - certain sheets have formulas and these have PATH information after the copy operation along with the original formula

    What starts out simply as
    =IF('Input Page'!B$86="Yes",0,('Input Page'!B$87*'Input Page'!B$38+'Input Page'!B$88*'Input Page'!B$39+'Input Page'!B$89*'Input Page'!B$40+'Input Page'!B$90*'Sheet Metal Input Page'!B$47+'Input Page'!B$91)/E104)

    before the copy, ends up as

    =IF('C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!B$86="Yes",'C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!E$36/E107,'C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!B$70/'C:\test updater - 7-28-2011\updates\[newfile.xls]Multi Use Items'!E107)

    after the copy.


    The code to copy a sheet from one file into the other is
    Please Login or Register  to view this content.

    What options can I use to NOT get all that PATH information stuffed into my formula?
    (I still need the formulas, just without all that PATH information)

    Thanks,

  2. #2
    Forum Contributor
    Join Date
    04-12-2006
    Location
    Morgan Hill CA
    Posts
    107

    Re: Formulas contain PATH info after copy/paste

    Although it would be great if there was an answer to this --- because having Excel add that PATH info into each formula when copying a sheet from one workbook to another is painful.... I've actually found a workaround to this specific issue.

    The only thing I CAN figure is the following.... The formula in my worksheet was WAY long and the directory PATH I was using was also pretty deep for my test. When I changed the PATH to something shorter, I no longer received the issue that caused me to write this issue in the first place.

    Thanks for the "views" and if anyone comes up with an answer to the PATH info in the copying from one sheet to the next, I'd like it. I have to "normalize" each sheet that is copied to remove the PATH info (to avoid "links" errors) which takes time in my processing...

    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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