Related Posts
Does EY send any goodies pre-hire?
Anyone waiting for a call from Ross today?
Additional Posts in Excel Genius
Google Sheets vs Excel - pros? cons? differences?
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
Best to just copy the worksheet (right click tab name) to the new workbook
Don't let a senior enforce their incompetence on you!
Then break the links.
It will only "hardcode" the amounts that had references to an external workbook. The rest of the formulas will stay intact.
You need ASAP Utilities! It’s an excel add in that can so that and much more
I saw on another thread it’s available through your EY AppStore? For us, I had to request through our internal service desk
Does Deloitte have said ASAP Utilities software? Can’t find it in our catalog, anyone know where to get it?
Save As...
Or press the F12 key. Everything will be there just as it was in the original
Do you mean without creating external links to other files or to the original file?
Other files
I see ASAP toolbar in the EY AppStore but it says Approval Required. What approval do I need to get?