HomeMy WebLinkAboutPart sportsWhere did my worksheet go?
How do I make sure this tips sheet isn't exported with the QuickBooks report in the final workbook?
How can I customize and update my worksheet?
Troubleshooting: Why don't my links work correctly after exporting data?
When you export data to a new workbook, your new worksheet containing exported data goes to Sheet 1. When you export to an existing workbook,
the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next available number in the series.
Before exporting, on the Export Report Basic tab, deselect the option to include the instruction worksheet.
You can set up Excel links between 2 or more worksheets. (See Microsoft Excel Help for details about linking in Excel.) You can use this
feature to setup links between a QuickBooks summary report and your customized sheet.
Be aware that any difference in the structure of the current report from the report that you used when setting up links, can cause mismatch
in the links between worksheets. If you are seeing wrong data in your customized worksheet, then you may have:
>> Choose one sheet as your source worksheet into which you'll export QuickBooks data. Then create another worksheet where you can
customize your data and link the data between that sheet and the source worksheet.
>> Export your source data to an existing worksheet and overwrite the current data so that the new data is used by any Excel links and formulas.
>> Create Excel links between a QuickBooks data worksheet and another worksheet in the workbook.
>> Moved or deleted elements, or changed the structure of the report in some way? For example:
>> You are using a report related to accounts and have account(s) with no activity associated and did not choose to display "All rows".
>> Deleted exported data sheet which serves as data source.
You might have moved or deleted items from item list which gets used in a report like Inventory Valuation report.
You might have moved or deleted accounts from accounts list which gets used in a report like Profit and Loss standard report.
TIP: Choose display All rows (available for most of the reports), Select Modify report->Display->Advanced->Display Rows->All rows
Instructions for Exporting QuickBooks data
TOTAL
6303 · Groups and Meetings
Total 6303 · Groups and Meetings
6303.18 · Participatory Sports
Total 6303.18 · Participatory Sports
Type
Bill
Bill
Bill
Bill
Date
4/16/2010
5/13/2010
5/13/2010
6/2/2010
Num
42192
42193
Name
Vail Valley Softball Club, LLC
On Target Challenge, Inc
On Target Challenge, Inc
Triple Corwn Baseball
Memo
3/3 of amount
Initial Dep for Hosting Fee for Challenge
Installment #2 for Hosting Fee for Challenge
VOID: Vail Valley Rally, July 9-11, 2010
Amount
5760
5000
9000
0
19760
19760
19760