Hi,
I have an excel file that takes long to open/save.
The sheet is designed to take test data and analyse and produce graphs/ test report. Even with no data entered it can take ~2 minutes to open or close the file.
The files contains conditional formatting, named ranges, a number of macros (if these make any difference?).
I've tried looking through existing threads for solutions i.e. searching for external links, disabling 'save external link values), but haven't solved the problem.
I have also tried saving locally & on the network, both give the same issue.
Is there anything you guys can suggest?
Thanks in advance.
Bookmarks