Modern File Viewer web part issues displaying ranges in Excel files

%3CLINGO-SUB%20id%3D%22lingo-sub-111266%22%20slang%3D%22en-US%22%3EModern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111266%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BGreetings%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%20the%20modern%20file%20viewer%20web%20part%20on%20a%20page%20to%20simply%20display%20a%20portion%20of%20a%20given%20spreadsheet%20on%20the%20page.%C3%82%26nbsp%3B%20I%20can%20successfully%20select%20the%20spreadsheet%2C%20choose%20Range%2C%20and%20then%20am%20asked%20to%20specify%20the%20Sheet%20name%2C%20Starting%20Cell%2C%20and%20Ending%20Cell%20for%20the%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoing%20so%20errors%20out%20with%20%22The%20named%20item%20is%20either%20not%20available%20in%20the%20workbook%20or%20was%20not%20selected%20as%20a%20named%20item%20for%20viewing%20when%20the%20workbook%20was%20published.%20The%20named%20item%20may%20also%20be%20located%20in%20a%20hidden%20range%20of%20cells%20or%20in%20a%20collapsed%20outline.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20help%20on%20the%20page%20to%20show%20what%20example%20values%20are%20for%20the%20range%20options%2C%20so%20i'm%20not%20clear%20i've%20specified%20the%20Sheet%20name%2C%20starting%20cell%2C%20and%20ending%20cell%20correctly%20(seems%20obvious%20however).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHis%20is%20a%20basic%20scenario%2C%20so%20i'm%20thinking%20this%20should%20work%20easily%20enough%20-%20any%20ideas%20what%20i'm%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-111266%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efile%20viewer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328774%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328774%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20Exactly%20what%20I%20needed.%20I%20tried%20double-quotes%20but%20not%20single.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-115305%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-115305%22%20slang%3D%22en-US%22%3EHi%2C%20we%20recently%20ran%20into%20this%20issue%20and%20were%20scratching%20our%20heads%20until%20I%20figured%20out%20our%20problem.%20When%20entering%20the%20Sheet%20name%2C%20if%20it%20has%20any%20spaces%20it%20must%20be%20surrounded%20in%20single%20quotes%2C%20i.e.%3A%20'Sheet%20Test%2001'%20Hopefully%20that%20helps%20you%20or%20points%20you%20in%20the%20right%20direction%20if%20you%20are%20using%20non-standard%20characters.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113818%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113818%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%202nd%20user%20wanting%20to%20display%20a%20range%20of%20cells%20in%20an%20excel%20spreadsheet%20on%20a%20sharePoint%20page.%26nbsp%3B%20I%20will%20keep%20looking%20into%20how%20to%20correctly%20specify%20range%2C%20starting%2Fending%20cells.%26nbsp%3B%20Any%20Help%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860175%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F78667%22%20target%3D%22_blank%22%3E%40Freddy%20Grande%3C%2FA%3E%26nbsp%3BAlso%20worked%20for%20me.%26nbsp%3B%20I%20don't%20know%20how%20you%20figured%20this%20out%2C%20but%20it's%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1191315%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20File%20Viewer%20web%20part%20issues%20displaying%20ranges%20in%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191315%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F78667%22%20target%3D%22_blank%22%3E%40Freddy%20Grande%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 Greetings all,

 

I am trying to use the modern file viewer web part on a page to simply display a portion of a given spreadsheet on the page.  I can successfully select the spreadsheet, choose Range, and then am asked to specify the Sheet name, Starting Cell, and Ending Cell for the range.

 

Doing so errors out with "The named item is either not available in the workbook or was not selected as a named item for viewing when the workbook was published. The named item may also be located in a hidden range of cells or in a collapsed outline."

 

There is no help on the page to show what example values are for the range options, so i'm not clear i've specified the Sheet name, starting cell, and ending cell correctly (seems obvious however).

 

THis is a basic scenario, so i'm thinking this should work easily enough - any ideas what i'm doing wrong?

 

Much thanks!

 

Scott

6 Replies

I have a 2nd user wanting to display a range of cells in an excel spreadsheet on a sharePoint page.  I will keep looking into how to correctly specify range, starting/ending cells.  Any Help appreciated! 

 

Cheers,

Scott

Hi, we recently ran into this issue and were scratching our heads until I figured out our problem. When entering the Sheet name, if it has any spaces it must be surrounded in single quotes, i.e.: 'Sheet Test 01' Hopefully that helps you or points you in the right direction if you are using non-standard characters.

Thanks. Exactly what I needed. I tried double-quotes but not single.

@Freddy Grande Also worked for me.  I don't know how you figured this out, but it's much appreciated!

A bug on the File Viewer web part that still exists since 2017... And it is/should be a low hanging fruit to fix. 
Mentioning @Mark Kashman, probably he can forward it to the engineering team.