c have been sent an Excel Spreadsheet at work to Complete. The data on the
sheet refers to 150 of my colleagues. As I am not privy to the information
requested I have had to forward it to all the people concerned. When the
spreadsheets are sent back I have to copy the data into the Master
spreadsheet. As the Master spreadsheet reacts very slowlyI wondered if there
was a way to speed things up? I have changed the automatic calc to manual and
this has helped a bit, but when I have two spreadsheets open I keep getting
the €œnot responding€� message and the only option is to closed down Excel.
Does anyone know what other steps I can take in order to speed things up and
prevent Excel from freezing? Unfortunately I cannot do anything to the PC,
mores the pity!