Category Microsoft Excel

Use Google Sheets to access protected Excel files

Aim: To access hidden sheets in Excel files with protected structures using Google Sheets. In an earlier post, I described how to unhide Very Hidden Sheets in Excel. That method does not work if the workbook structure has been protected. In this example, Sheet 2 has been hidden & attempting to unhide it using the […]

Unhide Very Hidden Sheets in Excel

Aim: To unhide Very Hidden Sheets in Excel. As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet (yuck, I know!). Based on some of the formulae in the┬ávisible sheets, it was apparent that there was another sheet hidden in the file. However, it was not possible to […]

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!