Update formulas to new sheet at once without Control Center
Hi everyone. I am hoping you can help me. I have a large sheet and with the new year coming up I have to recreate the sheet. I have a reporting roll-up sheet with lots of formulas and would like to replace all the old sheet reference names to the new sheet. I have tried Find and Replace but thats not working. I manually tried changing the name but keep getting Invalid Reference. I do not have access to Control Center. Can you anyone assist me on how I can update the formulas to a new sheet? Thanks Brian
Help Article Resources
Check out the Formula Handbook template!