Link to home
Start Free TrialLog in
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 :-(
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Prew
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
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