stocks data type problem in pivot table

Question

Excel workbook has problem at startup when it contains a pivot table that is sourced from a table that has a Stocks data type column. This has just recently developed. Worked fine for years. First you get:

Then:

Then when you click to view the log file:

This now happens at every startup of the workbook

Answer 1

I guess it is a bug. You may create a support ticket to Microsoft to fix this bug.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

Answer 2

I'm not sure what you mean by this but the problem that I have described is happening spontaneously to many users who have used the workbook for almost a year now.

I have linked another copy of the same workbook below. You should be able to open it without problem. Turn AutoSave off.

The only thing that you need to do to break it is to convert a stock symbol in the Symbol column on the Portfolio Trades tab (Trades table). If you the save and re-open, you will get the error message. It may take a second opening and saving to get the error. If you Delete the pivot table from the Portfolio Summary tab on the original working version, this problem disappears. If you add another pivot table sourced from the Trades table, the problem reappears when you add a converted Stock symbol to the Trades table.

The problem appears to be with pivot tables that contain a converted stock symbol column.

You may not be familiar with converting the Stock symbols. Enter msft into the first Symbol cell. Move back to the cell and, on the Data menu, click Stocks.

The protection password is IwmnM1

TWMN WealthMachine - Copy5.xlsm

Answer 3

How do you get that file? It seems file is corrupt when someone transfer it from one machine to another.

Is there any backup of that file? You will need to find the origanal one to make the povit table work.

Answer 4

TWMN WealthMachine - Copy.xlsm

IP has been stripped out.

An issue like this with pivot tables in 365 was reported as early as 2017.

Answer 5

Could you share a test workbook to reproduce your issue?

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

*Please make sure you have removed any sensitive or private information in the sample file before uploading.

Could you share the Excel version? It will help to determine whethere it is a version bug.