Lock Live Formula From Changing

[likeatiger2509]

Hi All

wondering if someone could help me out?

i have a spreadsheet that reads its values from another spreadsheet.

however once a month the values in the source sheet change.

i would love to be able to change the value in the source sheet for my new rates, without effecting the old rates on the old sheets.

any ideas??

 

[Robert Mika]

Hi wand welcome to the forum.
One way woudl be to open the old sheet and Click "Do not update", then Data-->Edit Links-Break Link