Home

Saving Excel freeze panes as HTML

%3CLINGO-SUB%20id%3D%22lingo-sub-472338%22%20slang%3D%22en-US%22%3ESaving%20Excel%20freeze%20panes%20as%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472338%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Microsoft%20Office%20Professional%20Plus%202013%20on%20a%20Windows%207%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20ton%20of%20data.%26nbsp%3B%20I%20want%20to%20distribute%20it%20to%20the%20team%2C%20but%20don't%20want%20to%20allow%20update.%26nbsp%3B%20Yes%2C%20I%20could%20make%20it%20read-only%2C%20but%20saving%20it%20to%20HTML%20gives%20me%20the%20best%20user%20experience%20by%20displaying%20the%20data%20in%20their%20browser.%26nbsp%3B%20The%20file%20is%20a%20.xlsm%20file%20and%20I%20have%20placed%20an%20index%20on%20it.%26nbsp%3B%20The%20index%20page%20displays%20perfectly%20and%20all%20the%20hyperlinks%20work%20correctly.%26nbsp%3B%20However%2C%20I%20would%20like%20to%20retain%20the%20freeze%20pane%20settings%20for%20each%20sheet%20so%20the%20headers%20stay%20put%2C%20and%20occasionally%20the%201st%20column%20stays%20put%20when%20scrolling%20to%20the%20right.%26nbsp%3B%26nbsp%3B%20I've%20searched%20and%20mostly%20come%20up%20with%20how%20to%20freeze%20panes%3B%20I%20know%20how%20to%20do%20that.%26nbsp%3B%26nbsp%3B%20I%20edit%20the%20html%20file%20in%20NotePad%2B%2B%20and%20found%20a%20few%20references%20to%20'%3CFREEZEPANES%3E'%20%26nbsp%3Bbut%20don't%20understand%20where%20to%20put%20it.%26nbsp%3B%20I%20attempted%20to%20put%20it%20one%20one%20sheet%2C%20but%20it%20corrupted%20the%20html%20and%20I%20was%20unable%20to%20make%20it%20work.%20%26nbsp%3B%20Not%20familiar%20with%20editing%20Excel%20as%20html%2C%20other%20than%20just%20standard%20markup.%20%26nbsp%3B%20Any%20assistance%20would%20be%20fantastic.%26nbsp%3B%20Thank%20you%20in%20advance.%3C%2FFREEZEPANES%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-472338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Louie Warren
Occasional Contributor

Using Microsoft Office Professional Plus 2013 on a Windows 7 box.

 

I have a spreadsheet with a ton of data.  I want to distribute it to the team, but don't want to allow update.  Yes, I could make it read-only, but saving it to HTML gives me the best user experience by displaying the data in their browser.  The file is a .xlsm file and I have placed an index on it.  The index page displays perfectly and all the hyperlinks work correctly.  However, I would like to retain the freeze pane settings for each sheet so the headers stay put, and occasionally the 1st column stays put when scrolling to the right.   I've searched and mostly come up with how to freeze panes; I know how to do that.   I edit the html file in NotePad++ and found a few references to '<x:FreezePanes>'  but don't understand where to put it.  I attempted to put it one one sheet, but it corrupted the html and I was unable to make it work.   Not familiar with editing Excel as html, other than just standard markup.   Any assistance would be fantastic.  Thank you in advance.

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies