Home

MS Excel Template - scroll bar not appearing when outside date range

%3CLINGO-SUB%20id%3D%22lingo-sub-358626%22%20slang%3D%22en-US%22%3EMS%20Excel%20Template%20-%20scroll%20bar%20not%20appearing%20when%20outside%20date%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358626%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20this%20template%3B%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FProject-timeline-TM33545035%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FProject-timeline-TM33545035%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eadded%20activity%20dates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20Timeline%20is%20not%20showing%20horizontal%20scroll%20bar%20as%20expected%20in%20the%20date%20range.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Escroll%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007138%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20Template%20-%20scroll%20bar%20not%20appearing%20when%20outside%20date%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007138%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20here%20-%20displays%20OK%20when%20opened%20from%20within%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007561%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20Template%20-%20scroll%20bar%20not%20appearing%20when%20outside%20date%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007561%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293326%22%20target%3D%22_blank%22%3E%40kellir%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECouldn't%20see%20the%20scroll%20bar%20either%20when%20I%20opened%20your%20file.%20Studied%20the%20template%20to%20see%20what%20the%20scroll%20bar%20is%20actually%20doing.%20Could%20then%20insert%20a%20new%20scroll%20bar%20(via%20the%20%22Developer%22%20ribbon)%20and%20link%20it%20to%20a%20cell%20named%20%22WindowOffset%22.%20This%20happens%20to%20be%20D26%20in%20the%20hidden%20sheet%20%22calcs%22.%3C%2FP%3E%3CP%3EAttached%20a%20new%20version%20of%20your%20workbook%20with%20the%20scroll%20bar%20in%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
kellir
Occasional Visitor

I downloaded this template;  https://templates.office.com/en-us/Project-timeline-TM33545035

 

added activity dates.

 

the Timeline is not showing horizontal scroll bar as expected in the date range.

2 Replies

Same issue here - displays OK when opened from within Excel.

@kellir 

Couldn't see the scroll bar either when I opened your file. Studied the template to see what the scroll bar is actually doing. Could then insert a new scroll bar (via the "Developer" ribbon) and link it to a cell named "WindowOffset". This happens to be D26 in the hidden sheet "calcs".

Attached a new version of your workbook with the scroll bar in it.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies