I am exporting report data to sheet1 of a workbook, and trying to link sheet 1 data to a more comprehensive report in sheet 2.using copy-paste-link. When I change the date range in QB and export to sheet1l sheet 2 has #REF.....
What am I doing wrong????? Thanks for any help...
John
This sounds more like an Excel problem. I can't think of anything that would cause this. Does anyone else have any ideas?
skip to main |
skip to sidebar
Free QuickBooks help from experienced accounting professionals. Quickbooksblog.com is a blog dedicated to QuickBooks where small business owners, accountants, bookkeepers, CPA's, and others can come together and discuss problems.! Send questions you would like posted to blogs@sassardcpa.com
Search
Followers
Blog Archive
-
►
2010
(9)
- ► 04/25 - 05/02 (6)
- ► 04/18 - 04/25 (3)
-
►
2006
(3)
- ► 08/27 - 09/03 (1)
- ► 08/20 - 08/27 (1)
- ► 07/16 - 07/23 (1)
-
▼
2005
(118)
- ► 09/18 - 09/25 (1)
- ► 09/11 - 09/18 (9)
- ► 08/14 - 08/21 (1)
- ► 08/07 - 08/14 (9)
- ► 07/31 - 08/07 (16)
- ► 07/24 - 07/31 (4)
- ► 07/17 - 07/24 (2)
- ► 06/26 - 07/03 (13)
-
▼
06/19 - 06/26
(24)
- Using Financial Statement Designer.
- Help Needed! QuickBooks Problem on Tiger OS
- Setting up Your Beginning Balance Sheet.
- Inventory Aging Report.
- Manufacturing Inventory.
- Help Needed!
- Opening a Mortgage Account.
- Sorting Bills by Due Date.
- Problem with Customer Balance.
- Balance Sheet Problems.
- Changing the QuickBooks Invoice Templates.
- Applying Payments
- I Deleted a Transaction...I Need it Back.
- I Don't Have My QuickBooks Password.
- Duplicate Deposits in the Check Register
- Trouble with Backup.
- Recording Merchant Fees.
- Rental Business Sample File.
- Tracking Salesman Commissions.
- Saving to Pay the Tax Man.
- Help Needed!
- Tracking Manufacturing Profitability.
- Sending a Deposit with a Purchase Order.
- I'm Back!
- ► 06/12 - 06/19 (3)
- ► 06/05 - 06/12 (19)
- ► 05/29 - 06/05 (8)
- ► 05/22 - 05/29 (8)
- ► 05/15 - 05/22 (1)
-
►
2004
(4)
- ► 11/28 - 12/05 (1)
- ► 11/14 - 11/21 (1)
- ► 11/07 - 11/14 (2)
About Me
Disclaimer
While we endeavor to provide the most accurate information possible, no warranty is expressed or implied. Each situation is unique and therefore you should consider the services of a professional who will be aware of all of the factors involved.
1 comment:
I use some filthy hacks to do some exporting and pasting with my Excel stuff (I don't even DARE trying to document the function that opens a connection and pumps data into the Access database). Everything that I needed to make it run was either in the help files (install ALL documentation when doing an Office install), or at the Excel forum at http://www.tek-tips.com/ (which has good FAQs for lots of stuff).
I always got #REF problems when copying from one workbook to another. Excel dutifully helped me out by keeping an absolute reference to the source workbook file, instead of a 'relative' reference (like just 'worksheet1'). Sometimes Windows applications are just too helpful if you ask me. The day they release QuickBooks for Linux, I'm done with Windows ;-)
Post a Comment