This has worked fine until just recently, although I can't pinpoint exactly when this became a problem because I didn't access some of the files for about a week. Although this file has extension .xls, it is not an Excel workbook but a plain text file. If I select Update Values - the dialog box says that one or more links could not be updated - to open all workbooks and press F9 to update and the status changes to Warning: open source.. If I select Open source, it says that it's already open.
But if I then save and close DCSWeb.xls, open and day.xls, and finally reopen DCSWeb.xls, I get no error messages. I'm not sure what way to go with this, but I do have a hint.
Perhaps the problem was with one of those other files? I bought the Navigator Utilities at and when i used it to display all the external links and their status..though I opened all the text files first, then the DCSWEB file (which I never had to do before) the utility shows an asterisk by each linked file if the file is open.
None of the text files have an asterisk, so somehow Excel doesn't seem to know they're open.
I also opened just the DCSWEB file, then went to Edit Links and selected Open Source. I then changed the workbook open code to show Workbooks.
If you have Power Point slides that report regularly updated financial or numeric data that comes from an Excel spreadsheet, you can save a lot of time by linking the data instead of retyping it.
This technique also allows you to secure the data from others changing it and prevents accidental transposition errors.
This article shows you the step by step procedure for importing linked data from an Excel spreadsheet into a Power Point slide (works in Power Point 2003, 2007, 2010, 2013, 2016).
If you want to learn about the three approaches to using Excel data in Power Point and the different methods for each approach, check out my After the Analysis e-course.
Step 1: Create the table in Excel The first step is to create the table of data in Excel so that it looks exactly the way you will want it to look on the slide, including titles, row labels, column labels, gridlines, text and background colors and text formatting.
Step 2: Copy the table in Excel Using your mouse or arrow keys, highlight the table of data in Excel. The slide layout with a title only is usually a good choice if the imported table will be the main focus of the slide.
On the Home ribbon, click the Copy button to copy the data table to the Windows Clipboard. Step 4: Paste the Table on Your Power Point slide On the Home ribbon, click the arrow below the Paste icon to bring up a sub-menu and click on Paste Special.