crashes

This is an age old question that people everywhere have tried to solve. I didn't notice it in this forum though. How do you prevent excel from crashing when you rename a worksheet if you have udfs. You'd figure by 2010 this would be solved, but it isn't.

Dear All, I am running a simple macro that copies and pastes data from one spreadsheet into another and then makes a calculation and loops around in order to repeat the procedure (usually around 40 or so times). The code is very simple and i'm pasting it below. Of late my spreadsheet has...

I have a pivot table in 2010 I'm using conditional formatting on. For most of the cells, the conditional formatting works as designed and I don't have any issues. On one of the rows of the pivot (call it Discount), I have the formatting apply to all of those rows in the pivot as the label...

Hi All, I have a few issues within Excel 2010 X64 version. What we have going on is that when EU are using Excel and they open 2 or more spread sheets Excel goes haywire and gives messages like ( Excel cannot complete this task with available resources. Choose less data or close other...

Hi chaps, I'm having problems with the following autotext function in excel (mac) 2008: When you type a word into a spreadsheet, excel remembers it. So if you start to type it again, the word appears in a box next to the cell you are typing in. If you click on the word, it automatically pastes...

I consistenly get the following error message when I open my Excel file Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the invonvenience. Error signature AppName: excel.exe AppVer: 11.0.8307.0 AppStamp:49ee85df ModName: unknown ModVer...

I have created a program in Excel (2007) to do some pretty simple things, which works quite well. When I do a Save or Save As, the file saves, but when I go to actually close the file, I get the Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the...

We use Excel 2003 SP3. We also use other applications such as Interwoven Worksite, MYOB and Quickbooks. We often copy and paste data eg profit/ loss account data from a MYOB file into excel worksheets. We also drop in pdf docs from Worksite and other excel spreadsheets often that have been...