Anyone know how to copy and paste mass amounts of data (formulas and text) from one workbook to another without creating external links?

like
Posting as :
works at
You are currently posting as works at

Best to just copy the worksheet (right click tab name) to the new workbook

like

Don't let a senior enforce their incompetence on you!

likesmart

Then break the links.

like

It will only "hardcode" the amounts that had references to an external workbook. The rest of the formulas will stay intact.

like

You need ASAP Utilities! It’s an excel add in that can so that and much more

like

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?

like

Save As...
Or press the F12 key. Everything will be there just as it was in the original

like

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?

Related Posts

How is Accelirate in terms of wlb, growth and learning opportunities?

like

What is the pay range for an Associate Decision Scientist (Grade 9 or 10) in Western Union?

like

What do you spend on your assistant's Christmas gift?

like

I want/need to upgrade my work bag situation. Any tips for briefcases or laptop bags? Thanks!

Is Stanzaliving in Pune is good for accommodation purpose.

like

Update on my boss-adjacent, hot F Director who made the “tied down” comment/hint/signal/joke - she scheduled a “work dinner” at 6:30pm today for me and her to chat about the strat deck I’ve built as a follow up from yesterday’s meeting. Anyone think she saw me blush lightly at her comment yesterday and she’s making a move, or is this strictly work related?

likefunny

Does EY send any goodies pre-hire?

like

Any one into San Diego real estate market. Moving from east coast and considering buying a family home but nothing decent is less than 1 mill and property prices have jumped like 15-20% in one year.

Hi all, has anyone worked at EY divestiture advisory group ? If yes, how was your experience like and is it different from deals advisory ?

like

Looking for suggestions on sending a thank you gift to a friend who made introductions and helped me land a new role. The guy is 30ish. Anything is fair game. Around $1k.

like
like

Hi fishes, if Iam joining Cognizant this September when will I get my first hike/promotion. Can you tell me some details about appraisal cycle in Cognizant? Thanks.
Cognizant Technology Cognizant

like

Help. Going through a bit of a mid-career crisis. I’ve been in planning for nearly 20 years and now...when I look at my boss, the CSO, that’s not what i aspire to. Maybe it’s burnout, maybe it’s climbing the ladder and seeing more of the corporate bs, idk. I need help seeing where to go from here. Research? Client side? Startup? I’m feeling lost 😩.

like

Could someone suggest a really good attorney for a contested divorce case in SF Bay Area ? Thanks

Anyone starting CBS j-term in 2022 looking for roommates?

like
like

Indian passport holders: has anyone used the VFS service to apply for Global Entry without visiting India? How long did the whole process take? Do they still do a police verification of your address in India even if you live here?

like

Anyone waiting for a call from Ross today?

like

Hi,
When does the salary revision happens in credit suisse? Is it yearly? If so which month?
I am a java developer. Yoe-4 yrs. Title - eno

I had HR round discussion on last Saturday with Mphasis, they told me that they will release offer letter on Monday or Tuesday but today is Friday I didn't receive offer letter yet, only received selection mail from talent team on Wednesday.

My joining date in other organization is 13-sept.

Should I wait for offer letter or start joining formalities with other organization?

like

Additional Posts in Excel Genius

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

What are your top Excel ninja tricks? Ones that few people know...

like

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?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

What are the most typical models you all build

likehelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal