1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Stocks data broken on Mac? "There's a problem with this formula"

I've used Stocks data many times in the past and never encountered this problem. Did something change recently?

"AMD" in cell A1, with Data>Stocks enabled.
"A1.Price" in cell A2, press Enter and get the below error:

"
There's a problem with this formula
Not trying to type a formula?
When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula:
• you type: =1+1, cell shows: 2
To get around this, type an apostrophe ( ' ) first:
• you type: '=1+1, cell shows: =1+1
"

Click on A1 and browsing the Stocks fields and clicking Price does nothing.
Click on A2 and typing "=A1." and browsing the Stocks fields and clicking any field and pressing Enter results in the same error.

Microsoft® Excel for Mac
Version 16.108.3 (26050324)

submitted by /u/zannnn
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article