My company has some tracking spreadsheets with complex formulas. We were
trying to copy the formulas from one file to another. When we did so, we ran
across a problem: rather than simply copying the formulas over and using the
relative cells in the new spreadsheet, the formulas were still referencing
the cells from the old spreadsheet.

Is there a way to simply copy the formulas and have them reference the
relative positions in the spreadsheet being copied to, and if so, how is that
done?

Insert an apostrophe to the left of the = sign. This converts the formula to
a text string. Then copy and paste.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jeremy" wrote:

My company has some tracking spreadsheets with complex formulas. We were
trying to copy the formulas from one file to another. When we did so, we ran
across a problem: rather than simply copying the formulas over and using the
relative cells in the new spreadsheet, the formulas were still referencing
the cells from the old spreadsheet.

Is there a way to simply copy the formulas and have them reference the
relative positions in the spreadsheet being copied to, and if so, how is that
done?

Jeremy

A workaround method..........

In source worksheet go to EditReplace

What: =

With: ^^^

Replace all.

Copy across to target file then reverse the process.

Close source file without saving.


Gord Dibben MS Excel MVP

On Wed, 4 Apr 2007 11:30:01 -0700, Jeremy
wrote:

My company has some tracking spreadsheets with complex formulas. We were
trying to copy the formulas from one file to another. When we did so, we ran
across a problem: rather than simply copying the formulas over and using the
relative cells in the new spreadsheet, the formulas were still referencing
the cells from the old spreadsheet.

Is there a way to simply copy the formulas and have them reference the
relative positions in the spreadsheet being copied to, and if so, how is that
done?