Keeping whole formula constant to new workbook
 

If i have a formula in workbook "HOME". For example the formula is =sum(a1+b1).

If I copy the whole page and paste it into a new workbook named "HOUSE" the
formula comes over as ='HOME'(a1+b1)

What could I do to make the formula stay the same regardless of what
workbook it was on???

Keeping whole formula constant to new workbook
 

Open House and Home
Use Windows | Arrange and tile them side by side
Hold down the CTRL button and drag the tab of the Home sheet to the tab list
on the HOUSE file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Hamed parhizkar" wrote in
message ...
If i have a formula in workbook "HOME". For example the formula is
=sum(a1+b1).

If I copy the whole page and paste it into a new workbook named "HOUSE"
the
formula comes over as ='HOME'(a1+b1)

What could I do to make the formula stay the same regardless of what
workbook it was on???