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
Extract name, address and ph# 8
Import Excel 2010 table into Access 2010 - not listed as range 0
Add to Dynamic Named Range 4
Dynamic charts with named range Windows 8.1 0
Dynamic charts with named range Windows 8.1 3
Autofill a dynamic range with a formula. 1
One extra x axis item that wont go away - can anyone help? 3

Top