Home

Create user-generated or auto-generated report from password-protected shared spreadsheet Excel 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-692918%22%20slang%3D%22en-US%22%3ECreate%20user-generated%20or%20auto-generated%20report%20from%20password-protected%20shared%20spreadsheet%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMy%20healthcare%20facility%20currently%20used%20a%20shared%2C%20password%20protected%20spreadsheet%20to%20schedule%20procedures%20for%20physicians.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20there%20a%20way%20I%20can%20create%20a%20user-generated%20report%20(basically%20a%20daily%20schedule)%20from%20the%20spreadsheet%3F%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI've%20attempted%20to%20link%20data%20to%20another%20workbook%20and%2For%20create%20a%20linked%20report%20in%20word.%20But%20to%20use%20that%20linking%20it%20wants%20the%20user%20to%20sign%20into%20the%20shared%20spreadsheet%20and%20that%20causes%20a%20lot%20of%20security%20issues.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EFailing%20with%20a%20user%20generated%20report%2C%20my%20fall%20back%20could%20be%20an%20automatically%20generated%20report%20to%20word%20or%20excel%20that%20could%20put%20the%20filtered%20items%20on%20a%20printer%20friendly%20format%20for%20those%20needing%20basic%20scheduling%20info.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20scenario%20would%20be%20for%20the%20user%20to%20go%20to%20a%20shared%20network%20folder%20and%20either%20create%20a%20schedule%20that%20has%20the%20latest%20info%20available%20from%20the%20secure%20spreadsheet%20or%20just%20have%20a%20report%20that%20can%20auto-generate%20every%20hour%20or%20so.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20looking%20for%20general%20ideas%20here%20and%20what%20folks%20think%20may%20work%20the%20best.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EOur%20facility%20uses%20Excel%202013.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20shared%2C%20secured%20spreadsheet%20is%20only%20accessed%20by%20three%20people%20and%20is%20on%20the%20same%20shared%20drive%20as%20the%20report%20folder%20if%20that%20helps.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWill%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-692918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Will Rast
Occasional Visitor

My healthcare facility currently used a shared, password protected spreadsheet to schedule procedures for physicians.

Is there a way I can create a user-generated report (basically a daily schedule) from the spreadsheet? 

I've attempted to link data to another workbook and/or create a linked report in word. But to use that linking it wants the user to sign into the shared spreadsheet and that causes a lot of security issues.

Failing with a user generated report, my fall back could be an automatically generated report to word or excel that could put the filtered items on a printer friendly format for those needing basic scheduling info.

The scenario would be for the user to go to a shared network folder and either create a schedule that has the latest info available from the secure spreadsheet or just have a report that can auto-generate every hour or so.

I'm looking for general ideas here and what folks think may work the best.

Our facility uses Excel 2013.

The shared, secured spreadsheet is only accessed by three people and is on the same shared drive as the report folder if that helps.

Thanks,

Will

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies