I have workbook & that file is Shared. While open that workbook is very slow to open & while save at time also very slow can u tell me what to do for fast open the file
Performance largly depend upon the contents of the file. if there are too many calculations going on at start up due to formulas or macro this may cause slow response of the file. Also, if workbook is placed at a shared location, the netwrok connectivity may also be a factor.
