User Profile
bob_sipes
Copper Contributor
Joined Jun 25, 2020
User Widgets
Recent Discussions
Copying formulas between spreadsheets without referencing the original spreadsheet
how do i copy a formula from 1 spreadsheet to another, and keep the formulas from referencing the original spreadsheet? I want the formulas to work in my new spreadsheet, instead of referencing the spreadsheet i copied them from. when i copy =SUM(Jan!U44) it turns into =SUM('[MORSUM 2017.xls]Jan'!U44) excel is adding the "morsum2017.xls" which is the source file name.Solved77KViews0likes14Comments
Recent Blog Articles
No content to show