Questions

excel sheet copying to new workbook

+
0 Votes
Locked

excel sheet copying to new workbook

dhays
How do I copy a worksheet to another workbook without references to the previous workbook, but keep all refernces within the sheet intact? I have tables and graphs that depend on information gathered from other sheets in the "from" workbook, I need a "snapshot" of that information and have it acted upon within the copied sheet, but when it is opened by someone it doesn't ask you to update information that isn't available to anyone but me.
  • +
    0 Votes
    robo_dev

    In order for the references to remain intact, the data must exist in the same location as it was previously.


    You can globally change the source of a link, but not sure this works for referernces:

    How TO: Change the source workbook for all links that use the source

    Open the workbook that contains the link.
    On the Edit menu, click Links.
    In the Source box, click the name of the link whose source you would like to change.
    Click Change Source.
    In the Change Source dialog box, click the source workbook (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) you want to refer to.

    Useful excel site:
    www.mrexcel.com

  • +
    0 Votes
    robo_dev

    In order for the references to remain intact, the data must exist in the same location as it was previously.


    You can globally change the source of a link, but not sure this works for referernces:

    How TO: Change the source workbook for all links that use the source

    Open the workbook that contains the link.
    On the Edit menu, click Links.
    In the Source box, click the name of the link whose source you would like to change.
    Click Change Source.
    In the Change Source dialog box, click the source workbook (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) you want to refer to.

    Useful excel site:
    www.mrexcel.com