Excel 2007 - Query MS Access DB

J

James C.

Hi,

I have inserted a query in my excel workbook that queries a MS Access DB. In
previous versions of excel you could then right click on the query (and
select properties... i think) and there would be an option that you could
select to autofill adjacent formulas so that they would automatically
populate as far down as the query goes. I can not find this in Excel 2007,
was this removed?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Access 2010 DB not fuctional with multiple users 2
How do I clear a form? 0
Connection of Excel 07 pivot table to Access Query makes DB read o 0
No Results returned from Access query 3
Using MS Query in Excel 2007 4
Deleting MS JET OLE DB references in an Excel 2003 file 1

Top