Excel 2013 is very slow in loading large workbooks, is there a way to open just the tab I want?

Hi Everyone,

I've sent some private messages out to try to get some more information on this issue to collect some of these workbooks to better understand this issue.

Thanks for your information on this issue.

Bill

Hi Jacques,

We are investigating, but it appears that the difference in protect performance in 2013 is due to some security measures the developers added in 2013.

Regards,

Anita

I've sent some private messages out to try to get some more information on this issue to collect some of these workbooks to better understand this issue. 

Bill

Please explain me what I have to do to send you my worbook also.

I already explained that I have exactly the same problem when I put some code to protect my worksheets an my workbook in the Workbook_Open event of ThisWorkbook.

After removing that code, the problem is gone and the workbook opens instantly.

Best regards

Jacques

Hello

Is there any news about resolving this problem obviously caused when opening a Workbook where this Workbook and/or its Worksheets are protected via VBA code?

When this Workbook and/or Worksheets are protected manually, i.e. without VBA Code but using the possibility inside the Excel Worksheet menu, I have noticed there's no problem opening the Workbook, which opens within a normal lenght of time.

Best regards

Jacques

Hello everyone,

I thought that I had posted the results, but it looks like I have not. We have looked at the source code on this and it is, unfortunately, the result of some security changes in protection, and quite by design. So there was nothing I could do to get a change. The development team is very conscientious about not reducing any security measures we have in place. You can see the known issues list for confirmation: http://office.microsoft.com/en-us/access-help/office-2013-known-issues-HA102919019.aspx?CTT=5&origin=HA102901439#_Excel_(release)

Thanks,

Anita