Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 36

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 46

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 52

Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 54

Warning: Use of undefined constant count - assumed 'count' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 58

Warning: Use of undefined constant debug - assumed 'debug' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/sqlfunctions.php on line 184

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 449

Warning: Use of undefined constant pw - assumed 'pw' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 515

Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/menu.php on line 3

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/search.php on line 3
Excel 2007 Compatibility How to unhide worksheet
How to fix anything
 About Us | Which Computer? | Memory Stick | Copy File | Site Map | 
What is a Browser | Search Engine | Windows Explorer 


Search for :



Excel 2007 Compatibility How to unhide worksheet

When opening a 2003 version of an Excel Spreadsheet in Excel 2007 I could reference but not unhide a sheet

To solve the problem I just kept a copy of the spreadsheet with the Hidden Sheet shown and reverted back to this one whenever a change was made.

It would not allow me to save as a Macro Enabled workbook as it contained version 3.0 and 4.0 Macros

I finally solved a method of unprotecting the worksheet structure and displaying the hidden worksheet as follows:-

1. Click on the Review Tab
2. Click on Protect Workbook
3. Untick the Protect Structure and Window
How to unhide Sheet in compatibility mode
4. Enter the password
5. Now right Click on a visible worksheet at the bottom
How to unhide Sheet in compatibility mode
6. Click OK
7. Select the hidden worksheet by clicking on it and click show
How to unhide Sheet in compatibility mode

    IP

©Copyright HPC Solutions Limited - All rights reserved (2012/13) .
Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.