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