Copy and paste spreadsheet and update the formula

Occasional Visitor

Hi Guys, I've a problem....

 

If I copy a spreadsheet in a second one how I can update the formulas?

 

I mean.

Spreadsheet name1 

I've a formula like that include the name of the spreadsheet1

 

if I make a copy of the spreadsheet in same file and i rename, how I can resolve this problem

Spreadsheet name 2 but the formula is spreadsheet1....

 

I ve to do it manually?

 

 

 

0 Replies