Cell Referencing

[drm184]

In excel 97, I have a text file that gets saved from Primavera Project Planner, that contains data that I want to use to automate other sheets in excel. I have no problem bringing the data into excel from the text file, and I have no problems creating references to the cells that contain the data that generate the numbers on the other sheets. The problem comes when I try to update the data. No matter if I use the macro, or if I just cut and paste the updated data over top of the current data, I get the #REF error. I tried using vlookup statements, and I tried just referencing the specific cells. No matter what, it comes up with #REF. In the formula the #REF displays right where the cell reference should be. For example:

VLOOKUP ("2008.5.11", '2008 - Present'#REF, 3, FALSE)

'2008 - Present'#REF

Any ideas on how I can run the macro to update the sheet without messing up the cell references?

Thanks for the help.

 

[Goska]

There is some discussion of this in the MS VBA forum in the thread:

Excel 95 - import data from closed workbook

See if this helps.