Question

Locked

Excel 2003 Data Linking from another Excel file question

By michaelc ·
Hi everyone,

I have 2 excel files, the source (data file), and the destination (printable label).

On the destination file, in a cell I have placed in the formula:

='Worksheet'!$F2

The data shows up perfectly on screen. However, as soon as I delete the Row 2 in the source, the destination becomes:

='Worksheet'!#REF!

The reason I deleted Row 2 in the source is so that I can move the data in source up one row and let the next row be my next set of data for the destination.

Is there a way to keep the formula to always reference the source cells?

Thanks

Michael

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums