Forum Discussion
remove IRM in Excel
Good morning, I have an excel file saved in one drive that when I try to open it in a browser I get this message: "Sorry, Excel can't open this document for editing in a browser because it is pr...
I started recreating pieces of my workbook one-by-one to a new workbook to try and isolate the issue. The error message when trying to open in a browser started occurring after I added a pivot table that used multiple consolidation ranges. Adding this pivot table seemed to automatically turn on something that the browser version considers IRM. (I re-created the pivot table from scratch instead of copying, so I know I didn't copy over any settings.
- This was very useful, thanks, just got the same issue, and indeed the pivot table messed it up
