• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2010 tabs disappear problem

aamirsq

Member
Hi,


when ever i open any excel file there is message "Protected View........Enable Editing" & when i click all my excel sheets and horizontal and vertical scroll bars disappear.


Then i have to go to options and select all above options to continue my work.


Whats causing this problem ?


Btw my excel files are being opened in compatibility mode & i tried to save my file in 2010 version but problem still remains (file size is decreased wala!!!)


Regards
 
Good day aamirsq


Try this


Go to File - Options - Trust Center - Trust Center button - Protected View - uncheck the first 3 options from the right side.


If that does not work you could try this......BUT BE WARNED MESSING AROUND IN REG EDIT CAN SHORTEN YOUR LIFE


go to regedit and add this key: HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelSecurityFileValidation with “EnableOnLoad”=dword:00000000


If that doesn't work, see this post: http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/fe348ce0-758d-4e5f-b181-5ede0e2d93a4/
 
Is it in all Excel files or just one ?

Does that one file have a macro that is doing that when you open the file ?
 
Back
Top