Forum Discussion
Features not allowed in Excel Web app
We use Excel web parts to display charts in SharePoint online. Our web parts were working fine for months but now don't show bars due to the reference cell formula not working. When attempting to open the spreadsheet in the Excel browser we get warning about features not supported and if we want to create an editable copy. If we say yes, we can then go to the reference cells and see the formula displaying #REF in the cell. However, there doesn't seem to be an issue with the formula because if after clicking in the cell and then hitting enter the #REF goes away and the formula renders the value. After saving the 'editable' copy the Excel web parts is fixed and the charts show up as they should.
So my question - can features that aren't supported in Excel web app hinder a web part from displaying data that may rely on the feature? Like a macro? We can't quite pin down the issue so any insight would be helpful. Has something changed recently in O365 that might have had an impact on how our spreadsheets work?
thanks!
Carlene
30 Replies
- Can you perhaps share the formula showing the REF error before and after the fix? If there are any range names involved, please include their formulas too.
The formula is below, which for some reason wants to be on two lines. If the formula is on one line, it doesn't work:
=TEXT([@[Due Date
(Day-Month-Year)]],"mmmm")I checked this morning and the spreadsheet I fixed on Friday is broken again. The references worked okay until the spreadsheet was modified, then the formula shows #REF again. It is looking at the date field next to it.
The spreadsheet is using table names. Here's a snip of the cells in Excel web app and the Table name. If the spreadsheet is opened locally in Excel, the formula displays okay.
Thank you,
Carlene
- Try editing the header (in the table) of that particular column and remove the line break that is in the name (an alt+enter adds a line break).
