External data Macro Problem Excel 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have aworkbook which imports external data from an Access 97 file. The
information imports corectly and adds the data to the bottom of the existing
data as I require. The problem I have is that I have formula's based on the
expected imported data, currently I have copied the formula into the empty
cell so when the external data populates the spreadsheet the formula works
with that info. When I open the spreadsheet and check the cells the data has
imported but the formula has changed referencing a different cell (usually
three cells further down). This does not happen on all the cells with formula
in them. Doeas anyone have any idea how I can prevent this from happening.
 
Difficult to say. Is it possible that the import is bringing in
additional rows or "overhead" entries that cause the formula to
reference the wrong cell?
 
You must log in or register to reply here.

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

How to manage new data with external data in Excel? 1
External reference for Offset formula 2
Formula Cells 1
External Data 1
Excel 2003 - Importing External Data - formatting problem? 2
Invalid cell reference 1
External Data and Formulas 1
How to Import data from a different .xls file 2

Back
Top