Hi, I'll be happy to help with this issue
can you try the following as a test?
go to Apple menu-->System Preferences-->Users
click the padlock icon and then click the + button to add a new user account
setup a new test user
and then restart the Mac
login as the new user, load Excel and open the spreadsheet
do you still get the same issue as that may indicate where the problem lies?
Let me know
Thanks, XXXXX XXXXX tried this but same result; takes 10 seconds for Ctrl-V and Ctrl-Z hangs and I have to do a Force Quit. Fraser.
Thanks - so that should rule out any preference issue at all - would you be able to mail the spreadsheet [email protected]
If you also include the link to this question that should get to me
I've not seen any response since you mentioned that under a new user the same thing happens?
I then sent a response asking if you could mail the file [email protected]
Hi Steve. Sorry for the delay, it's been a busy week. I will send the spreadsheet via email, and I will attach some screen shots. I had to go thru every sheet to obfuscate the information, which took a long time. But in doing that it seems as if I narrowed down the issue to some kind of corruption on sheet 12-12 (December 2012) which is about when things started to slow down. SO if you go to that sheet and highlight a couple of cells and then paste them elsewhere on the same sheet, it should take about 20 seconds to complete. Just now I got a run out of memory message and the spreadsheet crashed.
Hi STeve - JustAnswer says this is Closed but I sent follow up last night...Fraser
Thanks - am not sure why it is coming up as closed but will review when back in front of laptop later
Hi Fraser - have reviewed the screenshots, just waiting for the spreadsheet itself now
i sent it to that email address you gave me a few days ago hight up in the thread, sent yesterday. I'll attach it to this message.
not sure if it's uploading...
this was the address I sent it to...[email protected]
ok - have got it now
not sure why the e-mails never came through
so does the crash only occur when manipulating on the 12-12 sheet?
I doesn't. It crashed on other sheets as well, but it seems worse on the 12-12. I know this is weird but I'm convinced there's a cell on 12-12 somewhere which is corrupted.
although on the 'real' spreadsheet (the original) cut and paste is still slow on 1-13 etc. I will check now to see if this is replicated throughout. It does seem as if the obfuscation of the spreadsheet so you could see it has lessed the problem somewhat, but 12-12 is definitely still playing up.
I've done cut and pastes on sheets 'to the right' on the original and it's slow all over. It's difficult to explain but last night when I spent time blanking out all the text fields and making the numeric fields the same all over the spreadsheet it really seemed to slow down (and then crash) when I got to 12-12.
thanks - working around 12-12
can you see if this one is any better?
No, sorry, it's the same. cut and paste 0n 12-12 took about 20 seconds. I remembered a work spreadsheet I use fairly often that is pretty complaex (not as many sheets but tons of cross referenced cells). Have just tested it and it works instantly.
so it's some weird cell corruption somewhere!
thanks - will see what else I can find
what did you try last time?
I ran some repair scripts against it which seemed to improve things but clearly doesn't seem to have resolved the key issue
I'm going to open this to other experts for their input now as I can't think of many other procedures to try
OK, thanks. Can you replicate the wait time when you do a cut and paste?
Hi Steve: This seems to have been closed again?!? Fraser.
that's fine, thanks.
Thanks! Looks like it's fixed it . What did you do, as i need to make those changes to the original spreadsheet.
Fantastic, thanks, XXXXX XXXXX possible to have the script so I can run it myself? I have no idea how to do that. Please give an example of conditional formatting in my spreadsheet.
Rated and tipped...
Attachments are only available to registered users.
Perfect, I'll run it later. I had no idea I had CF in the spreadsheet. Many thanks for fixing this. The slowness a lot worse on the original spreadsheet, 20 seconds per transaction, and, as i use it every day it been driving me nuts for two months.
That's incredible; I have no idea how they got there. I know nothing about CF. Anyway, thanks for your help again. I applied the macro and it works! You can now close the case. Thank you again. Fraser.