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

Our take

If you're encountering the error message, "There's a problem with this formula," while using the Stocks data feature in Excel for Mac, you're not alone. Many users have experienced similar issues, particularly when trying to retrieve stock prices. Despite having successfully utilized this feature in the past, recent updates may have introduced unexpected behavior. To troubleshoot, ensure that you're correctly referencing your data and consider checking for any changes in Excel's functionality. Let’s explore potential solutions to enhance your spreadsheet experience.

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]

Read on the original site

Open the publisher's page for the full experience

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