Robert Mearns questions

Robert Mearns answers

• Create Excel file as html markup
• Prevent cell resize in excel [closed]
• Setting date cell format in excel xml
• Updating data source on multiple pivot tables within Excel
• How to automate converting Excel xls files to Excel xml format?
• Adjusting worksheet zoom level based on screen resolution
• Ctrl-End doesn't bring me to the last cell [closed]
• Excel formula to get ranking position
• How do get the index of a table's column by using a structured reference in excel?
• Excel - Copy the displayed value not the actual value