Hide document library from office applications

%3CLINGO-SUB%20id%3D%22lingo-sub-2739406%22%20slang%3D%22en-US%22%3EHide%20document%20library%20from%20office%20applications%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739406%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20looking%20at%20using%20a%20SharePoint%20document%20library%20as%20a%20time%20sheet%20system%20for%20our%20staff.%20We%20have%20upload%20excel%20templates%20that%20staff%20can%20then%20select%20to%20fill%20in%20and%20have%20created%20a%20view%20that%20only%20shows%20the%20documents%20you%20have%20created.%20This%20works%20perfectly%20in%20SharePoint%20but%20we%20have%20an%20issue%20if%20people%20open%20the%20time%20sheet%20in%20the%20Excel%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20hide%2Fprevent%20the%20document%20library%20from%20appearing%20in%20Excel%20as%20this%20allows%20anyone%20access%20to%20all%20the%20time%20sheets%2C%20rather%20than%20just%20there%20own.%20I've%20attached%20screen%20shots%20of%20both%20the%20SharePoint%20document%20library%20view%20and%20the%20Excel%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20would%20be%20greatly%20appreciated%20as%20this%20is%20going%20to%20prevent%20us%20from%20using%20this%20without%20a%20way%20around%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2739406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi all

 

We are looking at using a SharePoint document library as a time sheet system for our staff. We have upload excel templates that staff can then select to fill in and have created a view that only shows the documents you have created. This works perfectly in SharePoint but we have an issue if people open the time sheet in the Excel app.

 

Is there a way to hide/prevent the document library from appearing in Excel as this allows anyone access to all the time sheets, rather than just there own. I've attached screen shots of both the SharePoint document library view and the Excel view.

 

Any assistance would be greatly appreciated as this is going to prevent us from using this without a way around it.

 

Many thanks

2 Replies

@Sam Greatorex An alternative that you might want to consider - I mention it because I never enjoy using Excel for things like this - is to use Power Apps and a list in SharePoint. For my company of 1000 staff I built a simple app (screenshots are below from before it went live) in Power Apps that the user accesses from a page on our intranet, it does various calculations and saves it to the list. A user can view their own entries from a screen on the app but can't see anyone else's.

 

0-SP-list.png

 

1-customizedForm.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Hi Rob, many thanks for the reply and suggestion. We did think about using PowerApps but decided Excel would work better for our needs.
I have managed to find a solution to my problem by creating a Power Automate that removes all permissions on the file when created and then grants access back to the person who created it only.