ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   whenever open or save it is very slow to open (https://www.excelbanter.com/excel-discussion-misc-queries/239621-whenever-open-save-very-slow-open.html)

Nav J

whenever open or save it is very slow to open
 
hello,

i have lots of formulas in my productivity excel everything was going good,
once i pasted lots of data from another excel,this causes my Productivity
sheet is very slow to open and save...
please suggest me ...

Welsh Wizard[_2_]

whenever open or save it is very slow to open
 
Are you saving in .xlsx (XML) format? This is slower than Binary (.xlsb) but
there are some reports of issues with .xlsb format so you need to test that
it works for you. Also xlsb does not signify that it is macro free as .xlsx
does.

"Nav J" wrote:

hello,

i have lots of formulas in my productivity excel everything was going good,
once i pasted lots of data from another excel,this causes my Productivity
sheet is very slow to open and save...
please suggest me ...



All times are GMT +1. The time now is 08:57 PM.

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