Prev: Formulas
Next: Need help with organizing my excell data base
From: Eric Hall on 17 Mar 2010 11:25
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.
From: Gary Brown on 17 Mar 2010 14:09
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.
 | 
Pages: 1
Prev: Formulas
Next: Need help with organizing my excell data base