ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shared workbook opening and saving very slow (https://www.excelbanter.com/excel-programming/350290-shared-workbook-opening-saving-very-slow.html)

Ram

Shared workbook opening and saving very slow
 
I have a shared workbook with Macros that is opening and saving very slow. I
did copy all the sheets into an empty workbook to see if there was any extra
code tied to the sheets, 2 sheets had a problem. After I deleted the sheets
the workbook open and saved fin. After about 10 minuets it started to slow
down again, I rechecked all the sheets and they don't seem to have a problem.

Any suggestion on what is causing the problem.

Thanks

Ram

Shared workbook opening and saving very slow
 
I went into tools and changed the calculation to manuel with out
re-calcualtion before save and it's still very slow

"ram" wrote:

I have a shared workbook with Macros that is opening and saving very slow. I
did copy all the sheets into an empty workbook to see if there was any extra
code tied to the sheets, 2 sheets had a problem. After I deleted the sheets
the workbook open and saved fin. After about 10 minuets it started to slow
down again, I rechecked all the sheets and they don't seem to have a problem.

Any suggestion on what is causing the problem.

Thanks



All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com