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.