Forum Discussion

Copper Contributor

May 03, 2018

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 ope...

Excel Online

Macros & VBA

JKPieterse

Silver Contributor

May 07, 2018

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.

Carlene Bedient

Copper Contributor

May 07, 2018

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

JKPieterse
Silver Contributor
May 07, 2018
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).
- Carlene Bedient
  Copper Contributor
  May 07, 2018
  I checked out the formula. Once I took the space out of the the column name of the other cell, which had part of the name on another line, the formula now displays all on one line, but it is still not working.
  
  Carlene
  - JKPieterse
    Silver Contributor
    May 07, 2018
    Is there any way you can share the file with broken formula? you can remove all irrelevant (and sensitive) information from it.