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

John


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