I have a Powerpoint presentation that is linked to one Excel workbook. The document contains about 60 linked objects. This Powerpoint is shared among multiple users who update the data in the Excel file and then they update the links in the Powerpoint. We have trouble getting the users to store both documents with the same path and the same name. I would like a way to have a dialogue box tell them to select the file they want to link to and have all links update.
Does anyone have any suggestions, code, or add-ins that might help me? I realize this isn't just an Excel question, but I figured someone may have a solution for me. Thanks in advance for the help!
Does anyone have any suggestions, code, or add-ins that might help me? I realize this isn't just an Excel question, but I figured someone may have a solution for me. Thanks in advance for the help!
