As a result, I have spent many months facing the major challenge of trying to figure out ways to sync Google Sheets data with Excel spreadsheets in order to work efficiently.This arduous journey thankfully came to an end recently and the steps to the solution are provided below.
The cell references were all correct, but for whatever reason they would not update.
I tried a couple of things - "Formulas - Automatic" was checked, clicking "Calculate Now" and "Calculate Sheet" would not update the model.
Method 2: Paste Link When using this method, after you create the graph in Excel, you must format it exactly how you want it to appear on your slide since you cannot format it in Power Point. Click on the arrow below the Paste button on the Home ribbon and click on Paste Special.
Set all legends, labels, axes, gridlines, and other settings for the graph. In the Paste Special dialog box, click the Paste link radio button, select Excel Worksheet Object in the list and click the OK button.
Back in In Design we see this warning triangle which tells us that the table in the Excel file has been modified. Here is the table in In Design before (left) and after (right) the update.
Double-click on the triangle to automatically update the linked table. As you can see, the updated table lost its header settings.
Let’s say that you have a product catalogue or a price list and sometimes you need to apply changes to the product prices listed in a table.
If you just import the Excel file into In Design, then when it’s time to change the prices you’ll have to: This is NOT something I would love to do any time there is a price update.
These product features, in addition to the fact that it is free for everyone to use has been enough of a reason to drive many companies to switch from Excel to Google Sheets for day to day spreadsheet work.
However, this type of switch has not always been met with overwhelming support.
Not sure if its just my computer yet, currently testing the issue with different computers.