Avatar of agwalsh
agwalsh
 asked on

Using formulas in another file without including a link to file of origin.

I have a worksheet that has a lot of formulas that I can use in other files. What is the best way for me to transfer this sheet to another file? I find that if I use Move/Copy worksheet it works well EXCEPT that it is now referring to its file of origin :-(. Any suggestions on how I can use this sheet in other files without referencing the original file. Thank you. I think I should know this but turns out I don't :-(
ExchangeMicrosoft Excel

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Bill Prew

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Rob Henson

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bill Prew

@agwalsh,

Are you all set with this now, or do you need more help?  If all set, could you please close it out now.  If you need help with the question close process take a look at:



»bp
Rob Henson

Just realised might be referring to UDF with code in source workbook, use of the UDF when the sheet is copied will refer to original sheet unless code is in the specific sheet code rather than a separate module 
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23