Link Table to Excel Dynamic Named Range?

C

cnuk

As I understand it, Access is currently not able to have a linked table where
the source is a DYNAMIC named range in Excel. Yes, it works fine using
regular named ranges but using a dynamic named range that has the format of

='Raw Data Input'!$A$1:OFFSET('Raw Data Input'!$A$1,COUNTA('Raw Data
Input'!$A:$A)-1,COUNTA('Raw Data Input'!$1:$1)-1)

When I do this in Excel it causes the named range to be excluded as an
option in Access. That's very unfortunate for me because I use a LOT of
named ranges in my spreadsheets. Is this a feature that will ever be added
to Access? Does anyone know a good workaround?

Thank You
 

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

Multiple Dynamic Named Ranges across Columns 3
Drop Down with dynamic named range offsheet source list 14
VBA - retrieve data on last create named range from previous inserted named range 0
Import Excel 2010 table into Access 2010 - not listed as range 1
Dependent drop down dynamic range formula, off sheet. 7
Named Range maker code 9
Excel Limit to Named Ranges 1
Add to Dynamic Named Range 4

Top