Excel values not updating


11-Nov-2019 10:47

Now a worksheet may not be 100% "visible" if you stuck the charts all over the place in a worksheet.

So, the update link mechanism looks at the worksheet and looks for the upper left hand corner of the chart for the size info.

When updating an Excel spreadsheet formulas do not update automatically as values are entered or updates.

Instead the formula only updates after the formula is edited or the spreadsheet is closed and opened again.

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.

You’ll often need to sort your data, whether it be numerically, alphabetically, by color, or by icon.

You aren’t limited to sorting the rows—columns can also be sorted. For example, if your dataset has a date column, you can view the oldest data at the top, or you can view the newest data at the top.

Now, that upper left hand corner is always "visible" to the linking mechanism during update links since a chart sheet is 100% "visible".

We now turn the microphone over to Brian Reilly, Power Point MVP, who bares all (and grins it) Here's a fairly extensive list of things that happen with Excel linked charts to PPT and what you can do about it.