I continue to have this error come up when ever Excel recalcs and I can't
figure out where it is coming from. What kind of errors would be causing
this and where should I start looking.

My spreadsheet is retrieving pricing data from an Access table based on a
query that only imports the data for a chosen strategy code, importing this
data into a defined area 11 columns wide by 5000 rows high. It does this by
macro. The data never fills the entire 5000 rows, but it is variable length
depending on the chosen strategy code. Excel is then set up to do
calculations on the data columns in neighboring columns and then charting
various colums of the data and calculated data. The equations are already
defined for the entire 5000 rows whether there is data imported or not, and
if no data they are calculating a Zero answer. The charts are set up to be
sourcing some of the data series as the full 5000 row column of data and
other data series using named ranges to chart only a subset of the imported
data. The named ranges use the Offset command to dynamically change the
named region based on the data imported. I also have a cell that is linking
to another spreadsheet on the network drive via a vlookup command.

Thank you very much.

Invalid reference usually indicates that something is trying to find a file
that does not exist. Are you sure that the MSAccess database is not trying
to link to a no-existant file?
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Eric Hall" wrote:

I continue to have this error come up when ever Excel recalcs and I can't
figure out where it is coming from. What kind of errors would be causing
this and where should I start looking.

My spreadsheet is retrieving pricing data from an Access table based on a
query that only imports the data for a chosen strategy code, importing this
data into a defined area 11 columns wide by 5000 rows high. It does this by
macro. The data never fills the entire 5000 rows, but it is variable length
depending on the chosen strategy code. Excel is then set up to do
calculations on the data columns in neighboring columns and then charting
various colums of the data and calculated data. The equations are already
defined for the entire 5000 rows whether there is data imported or not, and
if no data they are calculating a Zero answer. The charts are set up to be
sourcing some of the data series as the full 5000 row column of data and
other data series using named ranges to chart only a subset of the imported
data. The named ranges use the Offset command to dynamically change the
named region based on the data imported. I also have a cell that is linking
to another spreadsheet on the network drive via a vlookup command.

Thank you very much.