Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Last Quote and Last Exch Date
Hi Vidas,
These fields are no longer updating. I have checked and it appears that the current share price is correct. Any idea why they would not be updating?
Joe
These fields are no longer updating. I have checked and it appears that the current share price is correct. Any idea why they would not be updating?
Joe
Comments
In Overview tab LastQuote is "mini" Pivot table. Check if you see anything strange there. So just select LastQuote date and then on the right you will see selected fields from PivotTable.
I am able to reproduce the problem. Could you please also send me all files from PSData folder?
I can see that in the workbook you send me, pivot tables are updated and appear to have the latest data, but Last Quote and Last Exch Date is not updated. But if I do data refresh, workbook and LastDate/Last Exch Date are updated right away.
So how do you refresh workbook?
I refresh by going to the "Data" menu and choosing "Refresh All"->"Refresh All".
Can you try to refresh it like that and see if your LastDate issue will go away?
That is exactly how I do a data refresh. I just tried again and it is still not updating those two fields.
Joe
1. What version of Excel are you using? I tested on Excel 2016 and it worked.
2. When you first reported, you said "They are no longer updated". Does that mean they were updating before? If so, do you remember what happened around the time it stopped updating (current date in that field).
Could you please make sure that you office is updated? File->Account_>OfficeUpdates/Update Options->Update Now.