When opening theExcel 2003 version of the workbook, it roughlytakes 5 seconds to open. This is about 60 MG in file size. We convert this toExcel 2010 and now it roughly takes about 17seconds to open. This is about 14 MG in file size. There's no VBA code in AutoOpen event. I am accessing both files in the C: drive. There are no conditionally formatted cells. Is there anything we can do to make the Excel 2010 version of the workbook open faster? Is there a setting that we must turn on? Many thanks,

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel 2010 version of workbook takes 3 times longer to open compared to Excel 2003

Thread starter AnaV100
Start date Jan 14, 2014
Tags

excel 2010 long time to open open workbook

AnaV100

New Member

Jan 14, 2014

When opening theExcel 2003 version of the workbook, it roughlytakes 5 seconds to open. This is about 60 MG in file size.<o

></o

>We convert this toExcel 2010 and now it roughly takes about 17seconds to open. This is about 14 MG in file size.<o

></o

>

There's no VBA code in AutoOpen event. I am accessing both files in the C: drive. There are no conditionally formatted cells.

Is there anything we can do to make the Excel 2010 version of the workbook open faster? Is there a setting that we must turn on?

Many thanks,