SOLVED
Home

Unable to edit or download embedded spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-122822%22%20slang%3D%22en-US%22%3EUnable%20to%20edit%20or%20download%20embedded%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122822%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20embedded%20a%20spreadsheet%20from%20OneDrive%20for%20Business%20into%20my%20company's%20Office%20365%20Sharepoint%20site%20(private%20group).%20None%20of%20the%20buttons%20at%20the%20bottom%20in%20the%20black%20stripe%20work%2C%20in%20fact%20the%204%20on%20the%20right%20aren't%20even%20clickable.%20See%20below%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20846px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F23253iFB1AEE8E0D32AC11%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20feels%20like%20a%20bug.%20It%20was%20embedded%20using%20the%20%22File%20viewer%22%2C%20and%20then%20selecting%20a%20shared%20file%20from%20the%20OneDrive.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20311px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F23254i73C2068390319C28%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture2.PNG%22%20title%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20click%20around%20in%20the%20sheet%2C%20but%20I%20can't%20edit%20anything.%20I%20am%20the%20owner%20of%20the%20sheet.%20I%20should%20be%20able%20to%20edit%20via%20the%20edit%20button%20on%20the%20lower%20left%20(it%20just%20pops%20up%20a%20new%20O365%20homepage)%20or%20click%20the%20download%20button%20on%20the%20lower%20right%2C%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuggestions%3F%20Thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-122822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123413%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20or%20download%20embedded%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123413%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20your%20modern%20sharepoint%20site%2C%20you%20have%20added%20the%26nbsp%3B%3CSPAN%3E%22File%20viewer%22%20SPFx%20web%20part.%20From%20this%20web%20part%2C%20you%20have%20pointed%20it%20to%26nbsp%3Bone%20of%20the%20~270%20supported%20file%20formats%2C%20Excel.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20was%20announced%20at%20Ignite%202017%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3EBuild%20richer%2C%20more%20dynamic%20pages%20with%20new%20web%20parts.%26nbsp%3BYour%20pages%20can%20include%20rich%2C%20dynamic%20content%20from%20across%20Office%20365%2C%20now%20including%20Planner%20and%20Microsoft%20Forms.%20There%E2%80%99s%20a%20new%20file%20viewer%20web%20part%20that%20can%20display%20previews%20of%20over%20270%20file%20types.%20You%20can%20embed%20content%20from%20anywhere%E2%80%94including%20Twitter%20feeds%2C%20YouTube%20videos%20and%20Amazon%20book%20recommendations.%20And%20you%20can%20surface%20content%20from%20more%20than%20100%20cloud%20and%20on-premises%20sources%20using%20the%20connector%20web%20part.%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3EBuild%20richer%2C%20more%20dynamic%20pages%20with%20new%20web%20parts.%26nbsp%3BYour%20pages%20can%20include%20rich%2C%20dynamic%20content%20from%20across%20Office%20365%2C%20now%20including%20Planner%20and%20Microsoft%20Forms.%20There%E2%80%99s%20a%20new%20file%20viewer%20web%20part%20that%20can%20display%20previews%20of%20over%20270%20file%20types.%20You%20can%20embed%20content%20from%20anywhere%E2%80%94including%20Twitter%20feeds%2C%20YouTube%20videos%20and%20Amazon%20book%20recommendations.%20And%20you%20can%20surface%20content%20from%20more%20than%20100%20cloud%20and%20on-premises%20sources%20using%20the%20connector%20web%20part.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSPAN%3EI%20haven't%20played%20with%20it%20yet.%20So%20that%20I%20understand%2C%20although%20the%20*file%20viewer*%20is%20allowing%20you%20to%20view%20the%20excel%20workbook%2C%20you%20expect%20the%20workbook%20to%20be%20*editable*%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20that%20the%20case%20when%20you%20use%20other%20formats%2C%20like%20PDF%20or%20Word%20or%20any%20of%20the%20other%20supported%20formats%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EDid%20you%20try%20this%20with%20any%20other%20workbooks%20-%20perhaps%20one%20with%20just%20a%20single%20worksheet%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20will%20test%20this%20over%20the%20weekend%20myself.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123238%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20or%20download%20embedded%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123238%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20absolutely%20a%20bug%2C%20and%20not%20one%20that%20has%20always%20existed.%20My%20organization%20relies%20on%20embedded%20spreadsheets%20for%20our%20website%20for%20over%20a%20year%2C%20and%20only%20today%20did%20we%20notice%20buttons%20there%20have%20stopped%20working--I%20would%20go%20so%20far%20as%20to%20guess%20that%20this%20is%20a%20widespread%20issue%2C%20as%20I%20couldn't%20get%20the%20buttons%20to%20work%20whether%20I%20was%20using%20my%20organization's%20files%20or%20my%20own%20from%20a%20personal%20OneDrive%20account.%20I've%20put%20in%20a%20ticket%20describing%20these%20symptoms--I%20would%20recommend%20doing%20the%20same%2C%20that%20usually%20gets%20us%20faster%20resolutions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Geoffrey Mack
Occasional Visitor

I have embedded a spreadsheet from OneDrive for Business into my company's Office 365 Sharepoint site (private group). None of the buttons at the bottom in the black stripe work, in fact the 4 on the right aren't even clickable. See below:Capture.PNG

This feels like a bug. It was embedded using the "File viewer", and then selecting a shared file from the OneDrive.Capture2.PNG

 

 

 

I can click around in the sheet, but I can't edit anything. I am the owner of the sheet. I should be able to edit via the edit button on the lower left (it just pops up a new O365 homepage) or click the download button on the lower right, right?

 

Suggestions? Thoughts?

 

 

2 Replies

This is absolutely a bug, and not one that has always existed. My organization relies on embedded spreadsheets for our website for over a year, and only today did we notice buttons there have stopped working--I would go so far as to guess that this is a widespread issue, as I couldn't get the buttons to work whether I was using my organization's files or my own from a personal OneDrive account. I've put in a ticket describing these symptoms--I would recommend doing the same, that usually gets us faster resolutions.

Solution

In your modern sharepoint site, you have added the "File viewer" SPFx web part. From this web part, you have pointed it to one of the ~270 supported file formats, Excel. 

What was announced at Ignite 2017:

 

Spoiler
Build richer, more dynamic pages with new web parts. Your pages can include rich, dynamic content from across Office 365, now including Planner and Microsoft Forms. There’s a new file viewer web part that can display previews of over 270 file types. You can embed content from anywhere—including Twitter feeds, YouTube videos and Amazon book recommendations. And you can surface content from more than 100 cloud and on-premises sources using the connector web part.

I haven't played with it yet. So that I understand, although the *file viewer* is allowing you to view the excel workbook, you expect the workbook to be *editable*?

Is that the case when you use other formats, like PDF or Word or any of the other supported formats?

Did you try this with any other workbooks - perhaps one with just a single worksheet?

I will test this over the weekend myself.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies