B
Bishop
I built a spreadsheet for my team to use. The spreadsheet has a couple of
macros that sort some data and populate some functions. When a team member
opens the spreadsheet there's no problem. When they run the macros there's
no problem. But if they close the spreadsheet and re-open it (after running
the macros) it shows "Calculating Cells: --%" in the lower left hand corner.
It goes from 0% to completion (slowly) and then seams to just lock up. (I
have an hour glass and it shows "Not Responding" in task manager) What could
be causing this?
macros that sort some data and populate some functions. When a team member
opens the spreadsheet there's no problem. When they run the macros there's
no problem. But if they close the spreadsheet and re-open it (after running
the macros) it shows "Calculating Cells: --%" in the lower left hand corner.
It goes from 0% to completion (slowly) and then seams to just lock up. (I
have an hour glass and it shows "Not Responding" in task manager) What could
be causing this?