How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in message
...
How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

Using that apostrophe makes it very difficult to do edit|replace to get all the
"formulas" at one time.

Bill Kuunders wrote:

Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in message
...
How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson

But makes it very easy *if* they're in a column by simply opening and
closing Text To Columns.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
Using that apostrophe makes it very difficult to do edit|replace to get
all the
"formulas" at one time.

Bill Kuunders wrote:

Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in message
...
How do I copy & paste formulas without the formulas linking back to
the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson

But if there's numbers that look like text ('1234123412341234), it might not be
worth the hassle.

RagDyer wrote:

But makes it very easy *if* they're in a column by simply opening and
closing Text To Columns.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
Using that apostrophe makes it very difficult to do edit|replace to get
all the
"formulas" at one time.

Bill Kuunders wrote:

Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in message
...
How do I copy & paste formulas without the formulas linking back to
the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson

--

Dave Peterson

True, but just shows all the ways XL can skin that cat.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
But if there's numbers that look like text ('1234123412341234), it might
not be
worth the hassle.

RagDyer wrote:

But makes it very easy *if* they're in a column by simply opening and
closing Text To Columns.
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"Dave Peterson" wrote in message
...
Using that apostrophe makes it very difficult to do edit|replace to
get
all the
"formulas" at one time.

Bill Kuunders wrote:

Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in
message
...
How do I copy & paste formulas without the formulas linking back
to
the
original source spreadsheet. The formulas should calculate only
from
internal cells and tabs .

--

Dave Peterson

--

Dave Peterson

If you're doing one cell, you could copy from the formulabar, then paste into
the formulabar. You'll have to adjust the formula yourself.

If you're doing lots...
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Do your copy|paste

Then reverse it (in both worksheets/workbooks):

Select the range
edit|replace
what: $$$$$
with: =
replace all

Since you're copying text, you may have to change the ranges.

Ineluctable wrote:

How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson

Worked like a charm.

Thanks

"Dave Peterson" wrote:

If you're doing one cell, you could copy from the formulabar, then paste into
the formulabar. You'll have to adjust the formula yourself.

If you're doing lots...
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Do your copy|paste

Then reverse it (in both worksheets/workbooks):

Select the range
edit|replace
what: $$$$$
with: =
replace all

Since you're copying text, you may have to change the ranges.

Ineluctable wrote:

How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson

If you paste to the formula bar rather than the cell you can copy one formula
without adjustment of addresses.

If you would like a macro to do this see
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ineluctable" wrote in message ...
Worked like a charm.

Thanks

"Dave Peterson" wrote:

If you're doing one cell, you could copy from the formulabar, then paste into
the formulabar. You'll have to adjust the formula yourself.

If you're doing lots...
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Do your copy|paste

Then reverse it (in both worksheets/workbooks):

Select the range
edit|replace
what: $$$$$
with: =
replace all

Since you're copying text, you may have to change the ranges.

Ineluctable wrote:

How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson