free excel invoice templates
You are here: HOME  >>>  Excel Invoice Manager

Copying Report Worksheets from One Invoice Template to Another

Copy the report worksheet

You can copy a report worksheet from one template to another. Here are the detailed steps:

  1. First make a backup copy of the destination invoice template. This allows you to start again in case something goes wrong during the customization.
  2. Open both invoice templates in Excel. Let's say the template into which you'll incorporate the new report worksheet is named "DestinationTemplate.xls", and the template from which you'll copy the report worksheet is named "SourceTemplate.xls".
  3. Click to activate the DestinationTemplate.xls window.
  4. On the bottom of the window right-click the name of the report worksheet that you want to replace with a new one, choose Delete from the menu.
  5. Click to activate the SourceTemplate.xls window.
  6. On the button of the window right-click the name of the report worksheet that you want to copy, choose Move or Copy.
  7. From the "To book" list, choose DestinationTemplate.xls.
  8. In the "Before sheet" section choose where to place the copied report worksheet in the destination template
    9. .
  9. Check "Create a copy" if you don't want to delete the report worksheet from the source template.
  10. Close the source template.
  11. Save and close the destination template file.
  12. Re-open DestinationTemplate.xls.
  13. Excel may display a message "The workbook contains links to other data sources" and asks whether you want to update the links, choose "Don't Update".
  14. Save and reopen the DestinationTemplate.xls. You should find that the "The workbook contains links to other data sources" message disappears. Try to generate a report by using the newly copied worksheet to see if it works or not.

Problems that need to be solved

The message "The workbook contains links to other data sources" appears because in the copied report worksheet created by Excel some cell names are linked to the original source template - that is, to the current template they are linking to an external data source. For example, if you copy the Customer Statement worksheet from SourceTemplate.xls to DestinationTemplate.xls, Excel creates a name oknCompanyName in the copied worksheet and makes it refer to the SourceTemplate.xls file.

Excel Invoice Manager deals with this situation by re-linking all the names/formulas to the current template. And, if there are worksheet-wide names that were created by Excel automatically during the copy process, Excel Invoice Manager redefines these names so that they become workbook-wide. All these happen in the background and you don't need to tell Excel Invoice Manager which name should be redefined.

For the purpose of safe, Excel Invoice Manager tries to redefine the names started with "okn" prefix only. All other names not defined by Excel Invoice Manager remain intact as created by Excel in the copying process. So if you have your own names defined in the source report worksheet, you may need to adjust those names and links manually if you still see the "The workbook contains links to other data sources" message or the report does not work, as detailed below.

Break links

To break links manually:

  1. Open the DestinationTemplate.xls file.
  2. Click Excel menu Edit -> Links in Excel XP/2003; or in Excel 2007 on the Data tab, click Edit Links in the Connections group.

    Note: The Links or Edit Links command are available only if the workbook contains links.

  3. On the Edit Links dialog box, click Break Links.
  4. When you are prompted to confirm that you want to break the links, click Break Links.
  5. Save the template once finished.

Please see Microsoft's document Frequently asked questions about using links in Excel 2002 and in later versions of Excel for more information.

Manager names

In earlier Excel versions, the name manager can be opened by clicking Excel menu Insert -> Name -> Define.

In Excel 2007, you can open the name manager by going to Formulas tab, Defined Names group, and then the Name Manager command.

Tip: You might need to unprotect your template/worksheet to make the commands available.

 
EXCEL INVOICE MANAGER Free Download and Try
LEARN MORE Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Setting up Company Information, Tax Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Copying Report Worksheets from One Invoice Template to Another Two Versions of Customer Statement Report Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Creating an Invoice Template with Additional Rows Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way Adding Postcode Cells Manually to Invoice Template More Topics Registration and Services Reference
Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer Sample Invoice Template: Replacing the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Sharing/Linking Tables between Access Databases Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices Customizing Invoice Template for Pre-printed Invoice Forms Charging GST Tax on Shipping Cost Invoice Form with Fixed or Static Product / Service Items Applying Discounts
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved