You could look in Excel help for "edit links"

Or don't bother with Excel help at all and waste your time posting and
waiting for someone to tell you......................

Your time is yours to distribute as you see fit so.............

In 2003 EditLinks

In 2007 DataEdit Links


Gord

On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R
wrote:

Where do I find this?

"Gord Dibben" wrote:

EditLinksChange Links generally gets the job done.


Gord Dibben MS Excel MVP

On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R
wrote:

I have built a set of spreadsheets that track our plant operation.
It consists of one sheet we call the input sheet that we put our daily
readings in ( power, water,motor hour meter, etc.) and twelve sheets
(January - December) that have the formulas to draw the information to the
appropriate equipment.
My plans were to at the years end to save as to the next years date, wipe
out my input page and start over. Here is my delima. The save as sheet still
tries to draw from the previous years input page. Any ideas ?
Thanks

.