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

Tagged with

#Excel alternatives for data analysis
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#Stocks data
#formula