|
I have a user who had a one-sheet, one-page spreadsheet where the most complicated formula was subtracting four cells. The spreadsheet opened very slowly and changing any cell took up to 5 seconds, with the mouse cursor changing to the hourglass/busy circle. This even happened with auto calculation off. I opened the sheet myself, on a much newer computer, and the same thing happened. The problem introduced itself when the user upgraded to Excel 2007. He opened an existing sheet, saved as... for the next month, and saved it as an xlsx file. The older files don't seem to have the problem, but the new one does. I copied and pasted the entire sheet to a new sheet and the problem was still there. I did paste special -> all and the problem went away. This is how we fixed the problem, but this begs the question, what the gently caress is the difference between paste and paste special -> all?
|
# ¿ Jan 14, 2010 17:45 |
|
|
# ¿ May 6, 2024 20:42 |