Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2021, 12:49 AM
pansegrau pansegrau is offline How to avoid a long load time for PowerPoint with linked excel charts? Windows 10 How to avoid a long load time for PowerPoint with linked excel charts? Office 2019
Novice
How to avoid a long load time for PowerPoint with linked excel charts?
 
Join Date: Apr 2021
Posts: 1
pansegrau is on a distinguished road
Default How to avoid a long load time for PowerPoint with linked excel charts?

Hi,

All of a sudden, a perfect PowerPoint and Excel-linked setup has taken a turn for the worse and the Powerpoint file is now using 10-12 minutes to open. It would be amazing to solve this issue with some guidance from the community. In advance, thank you for taking the time.

What:
A PowerPoint with linked Excel charts to be able to automatically update all graphs using a VBA macro
  • This presentation is uploaded to Sharepoint, as a non-macro presentation, and shared with the team for collaboration
    Until about 4-5 week ago this was a problem-free setup with unnoticeable load time when opening the PowerPoint-file

Problem:
The PowerPoint presentation will open but it now takes about 10-12 minutes from double-click to the file opening
  • The PowerPoint file will use about 20 seconds for the first 80% of the load and then 10-12 minutes for the last 20%
    The problem is just the same if I open a locally saved version of the Powerpoint presentation, or a version saved on SharePoint

Makeshift solution:
The problem with PowerPoint using a long time to load does not occur in two scenarios:
  1. If all links to any external files are broken


    If the linked excel workbook is opened before the Powerpoint
  • These two options are the current makeshift solutions but they are far from optimal as we collaborate with team members that does not have access to the linked excel workbook and because breaking links makes the presentation considerably less dynamic
Hypothesis: A new update from Microsoft is causing the Powerpoint to go through all links and this is causing the additional load time of 10 minutes

Additional information:
  • I have disabled Powerpoint from asking if it should update links. However, I don't think this should have any effect as the problem occurs before the file is actually opened.
    Excel-workbook: It is saved on my local hard drive, in this folder: C:\Finance_model. This is the only file linked to the PowerPoint presentation.

Best regards,
Andreas.
Reply With Quote
Reply

Tags
excel 2019, microsoft 365, powerpoint 2016

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple PowerPoint charts linked to one excel table bilbo85 PowerPoint 0 07-18-2020 06:24 PM
After updating linked excel charts in publisher, all charts are moved effinglife Publisher 0 05-23-2017 02:27 AM
Excel 2013, Problem with a shared file, takes long time to load and save and loads missing data PStark Excel 0 12-04-2014 07:52 AM
Update Link very slow -PowerPoint Charts & object, cells etc Linked to Excel johnseito PowerPoint 0 01-28-2014 06:24 PM
Faulty alignment of charts linked from excel to powerpoint Reem PowerPoint 0 05-25-2012 05:24 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft