Related Posts
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

Additional Posts in Excel Genius
Wait until they see INDEX...

New to Fishbowl?
unlock all discussions on Fishbowl.





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
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