Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Copying data and derived graph & pivot table (Excel 97/all)

    Hello,
    can anyone save me out of this one? It could spare me a lot of time...
    I'm trying to recover a huge corrupt Excelfile by copying-pasting all content to a new file <img src=/S/humpty.gif border=0 alt=humpty width=15 height=15>. However, the references of the coupled pivot tables & graphs keep pointing at the source data in the original file. Is there a way to copy them in such a way that they point at the same data-cells in the new file where they're pasted in? Tab names and location of the data are made identical to those in the original file...
    Hasse

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying data and derived graph & pivot table (Excel 97/all)

    Maybe this may help ( a bit)

    My flexfind utility is able to do search and replace inside most of Excel's objects. Maybe it can do the job?

    Find it at my site below.

    I doubt if it can S&R in the PT source data though, but who knows.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copying data and derived graph & pivot table (Excel 97/all)

    After you copy the info and you have the 2 files identical. Edit the links and change the source to the new file name.
    [Edit - links - change source (select current file)]

    This should break all the links to the original.

    Steve

Posting Permissions

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