I’m working with a massive old template that gets updated every year (so hella outdated links) which populates a lot of exhibits we use for reports. When I paste these exhibits into ppt... (cont’d)

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

Some of the exhibits are bar charts with data labels and a median line running through the exhibit, so occasionally you have the line over top of the labels and need to move them. But I’ll check to confirm that this linking to old sheets issue takes place regardless of where you copy the exhibit and paste it

like

I first paste them in normally (ctrl c + v), resize them and then recopy and paste them into the report as an enhanced metafile. The problem comes with recopying: PowerPoint connects those outdated links from prior spreadsheets (i.e., 2014) and refreshes a bunch of times/potentially causing a crash.

When I went to break the links in excel the file didn’t show any prior references, and neither does the PowerPoint. So how am I supposed to break these links? Everyone in my firm uses this spreadsheet so, a fix would eliminate a lot of heartache/inconvenient crashes. Thanks in advance!

Why can't you paste special as a metafile and resize after it's a pic? I think I'm not understanding the problem 🤔

I usually do one of two things when pasting from excel into ppt: paste special values with source formatting, or paste special metafile image. I don't like the dynamic linkage of data and updates and those two actions would break the link.

It's a pain, but we build all graphs in ppt. I just save formats as styles so it's an easy add in the future.

But to answer your question, check for named ranges and validation lists

Related Posts

Why do the London markets write hard-to-place risks for not a lot of premium?

like

Experienced folks pls share your views. I am planning to buy a 3bhk. All tower corners (4 sides) have 3bhk options available and I might get to choose inventory in any tower and on any floor. Point to note: North has City view, South has Hill view, W has Forest view & E has city view. If you were gonna buy a flat in this site what all things you would think and then make a decision. First time buying flat.

Post Photo
like

What do big product based firms ask in Front end dev interviews? If DS, do we require to prepare DS as thoroughly as a Backend Dev?

like

Case load= malpractice? Small plaintiff’s firm of 25 attorneys. I was a 2 year associate hired and given 50 active files in pre litigation status. 9 mos later a partner quit and I inherited 45 more. I got up to 105 files. Now I hover at 85 active files in varying stages of pre lit. I asked managing partner for help and was told to settle more claims to lessen my load. Is this what people consider negative work culture?

like

recently moved to a new city where i have to take the metro 20 min everyday each way. any recommendations on what’s to do during that time other than listening to music/audiobooks?

like

My accounting edge finance is not compatible with the new Mac OS. I do not need the $15/month subscription they offering as an upgrade since I’m a lone freelancer. I’ve always kept my own books and did my own taxes. Anyone else out there with a basic bookkeeping program recommendation for Mac would be appreciated.

like

What is service line in EY GDS? How Many service lines are there in GDS?

like

Hi i am currently working in Sopra Steria as a Senior Software Engineer. A new opening for ORACLE EBS Technical has opened. Let me know if any wants to apply. You can contact me at +91-9711867379
Sopra Steria

Post Photo

I am seeking new employment, I was recently laid off due to lack of work. I would very much appreciate any leads. I have a Bs in Construction Management and over 15 years experience with Revit and AutoCAD and 7 years of plumbing design. I have solid references and impeccable work ethic. I truly enjoy what I do. Working remotely the last three years has become a way of my life and supports our current situation well, therefore I am seeking a similar role but will consider other opportunities.

like

Let’s talk about spiders. They’re EVERYWHERE at my place. Same for you or nah?

likefunny

Hi Sharks,

Please guide.
I got selected in HCL.
They asked me to share the documents , but they didn't share the offer letter, it's been 1 week already.
Do they take time in releasing offer letters generally , or am I rejected already ?

Also, they mentioned 5% engagement bonus , and 8% annual bonus, do they give full amount , or some part of it.

How much an average candidate can expect from these bonus ?

like

Anyone looking for reference in Cognizant.
Please share your resumes with role, location and experience to
Arjun.muralidhar@cognizant.com

Skills: Angular JS, React, Angular, NodeJS, UX Design, UX researcher, Lead , Technical mentor, Technical Trainer, Technical writer, Campaign manager, Veeva, Drupal, Alfresco, Android, Documentum, Aprimo, AEM, WCS, ATG

Post Photo
like

Is there any stigma to saying no to an offer without another in hand? I landed an off-cycle offer at a decent fund but after thinking through, want to take a shot at some of my other funds as well

like

Looking for advice on tips and tricks for landing PE MBA internship, coming from consulting. What were the game changers for you?

like

What level could I expect going from Director of M&A Strategy group (running all DD’s) specializing in tech investments when lateraling to PE? would it be VP? or do I have to have the full experience to land that

like

Can anyone share first / second hand reviews about DESRI (DE Shaw Renewable Investments)? It’s a PE group within DE Shaw that solely invests in Renewable Energy companies.

like
like

A game of Among Us, but the imposter is one of your clients.

likefunny

I have a first round interview with my dream job tomorrow. I’ve prepared but I’m so nervous and I don’t wanna ruin my shot. Please advise me on what good questions I can ask? It’s a fast growing Tech company and the role is Senior Accountant. Thank you in advance! 🖤

like

Does anyone have recommendations for thought leaders/influencers in the M&A space? Looking for blogs, books, YouTube videos? Not currently in the space, trying to learn more as I’m thinking about a pivot after a few years in consulting/startups

likehelpful

Additional Posts in Excel Genius

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Wait until they see INDEX...

Post Photo
likefunny

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Dear auditors, please explain how you pick samples for substantative testing.

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How long did it take you to become good at excel? Like fast?

like

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

What are some of the unique use cases you have leveraged excel for?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Scan your QR code to download
Fishbowl app on your mobile

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