soupdragon
Distinguished Member
Another excel thread.
My issue.
I've 2 spreadsheets, lets call them work2016 and work2017.
Both sheets are almost identical but I've an extra sheet in 2016 that I don't have in 2017 that I want to copy it in. So when I copy in the 2016 sheet into the 2017 one, it links the formulas into the 2016 file. I want the formulas to stay the same but I don't want them linking to 2016.
For example, the formula might be really simple, like ='payroll'AB14 but when I move the sheet into the 2017 file it now reads =[work2016] 'payroll'AB14
I can manually adjust the formula so that it doesn't read the 2016 file but its a very large page and its going to take me ages to do it.
I just need to know the quick way
thanks in advance
My issue.
I've 2 spreadsheets, lets call them work2016 and work2017.
Both sheets are almost identical but I've an extra sheet in 2016 that I don't have in 2017 that I want to copy it in. So when I copy in the 2016 sheet into the 2017 one, it links the formulas into the 2016 file. I want the formulas to stay the same but I don't want them linking to 2016.
For example, the formula might be really simple, like ='payroll'AB14 but when I move the sheet into the 2017 file it now reads =[work2016] 'payroll'AB14
I can manually adjust the formula so that it doesn't read the 2016 file but its a very large page and its going to take me ages to do it.
I just need to know the quick way
thanks in advance