Update link to excel file in ppt for mac update#
Update link to excel file in ppt for mac full#
Update link to excel file in ppt for mac zip#

Update link to excel file in ppt for mac zip#

Zip up the updated source bundle: 'zip -r. Make sure you're in the right directory: 'cd /tmp/pptdoc' process the whole lot in one go using the technique below** open all of them in vim so you can manually edit them: 'grep -rn FILENAME.xlsx | xargs -o vi' open all of them with TextEdit so you can manually edit them in a Mac application: 'grep -rn FILENAME.xlsx | xargs -e' List all of the files you need to change: 'grep -rn XYZZY.xlsx' where XYZZY.xlsx is the name of your spreadsheet without the path you pasted before Type (without the quotes) ' /tmp' (note the space) and hit return so the file is copied to the /tmp directoryĬhange to the /tmp directory using 'cd /tmp'Ĭhange into the new directory 'cd pptdoc'

Select the file you want to fix in the Finder and drag/drop it to the Terminal window Type (without the quotes) 'cp ' into the terminal window (note the space) Open a Terminal window from Applications > Terminal.app No, seriously, create a backup of your original file.

Update link to excel file in ppt for mac update#

To update the links in the powerpoint to a new spreadsheet (if you've changed the name): YMMV.īTW, this will also require command line and text editing, so it depends on how much you're comfortable with using these tools on a Mac as an Office user. However, if you get it wrong, you could corrupt your file, so make a backup first. Note that this isn't pretty, but it does work. For me, the procedure below is easier than repasting all my charts and changing the color scheme for about 25 charts, but it might not be optimal if you only have one or two.

Update link to excel file in ppt for mac full#

I didn't figure out a good, user-friendly way to do this, but, if you have a presentation full of charts and you do something crazy like version the source spreadsheet using filenames (because nobody would ever do that), you need to update the links or recreate a bunch of files. This is the link that needs to be changed. It's classic Microsoft XML with heavy use of attributes, but what you want is the last line that references your file name. ppt/charts/_rels/ documents to change the filename of the Excel data source, zip it back up and then open the new document.Įach of the files in question is created for each embedded chart, and it looks like this (indented for clarity): What you need to do is update each of the. I'm copying the vast majority of the comment because it's relatively complicated. Here's a discussion that I found about it: Įdit: From the link posted previously, this appears to be the solution. I misread the title as asking to fix a broken link in an Excel chart, bit realized I was in r/powerpoint after I posted.

Just right-click the hyperlink and select Edit Hyperlink.

If you can't select Edit Links, that means it's a hyperlink rather than a linked object. Select Change Source, navigate to the file location, Select Change Source, then Close. In the Source File box, select the link you want to fix.