Question Submit

Thursday, June 23, 2005

Help Needed!

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...


This sounds more like an Excel problem. I can't think of anything that would cause this. Does anyone else have any ideas?

1 comment:

JBR said...

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 (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 ;-)