crash

Folks, I've researched till I'm blue in the face...literally. This is my last hope so I thought I would stop here. I've snooped around in these forums for awhile but never really posted. Thought maybe you all could help a brother out. My excel seems fairly unstable, it crashes almost daily...

My users build product spreadsheets in Excel to track items carried in their area. Columns for Vendor, Product, price, etc. Included in this, they also insert images into a column so they have a visual representation of their selection. We have an ongoing issue when they open these workbooks...

This just started happening yesterday with an .xlsm file that has a dependency to another .xlsm file. I can save the file as expected UNTIL I apply a sort - then the save action crashes Excel. It doesn't matter whether I apply the sort by macro or manually. I have another .xlsm file with the...

Hi there! I have a waiting list for group home admissions and code in VBA to send an entire row from one tab to another that has certain words such as "Admit" and "Cancel". When I use the drop down menu to select Admit, the screen freezes then pastes "Return" in the remaining status columns...

When I try to drag down a formula it is causing excel to crash. I have 400,000 rows of data and the formula contains a vlookup, so this is quite intensive procedure. However, if I write a vba sub which breaks the dragging down into 100 row bitesize pieces, it works fine. Takes a while but no...

Hey guys! Thank you for the immense help you have already given by being so active. I have an excel file with some VBA code (fairly new to the (for me) more advanced stuff). The code is working fine, and was working when I was creating it. Now when I make a change in the file, save, close...

Hi guys, I have a VBA script that takes data from two workbooks, modifies them and puts them into a third workbook. However at some point in the second loop of the script the process crashes and Excel freezes up. Are thee any ways to speed the script up to make it a little easier on Excel? The...

Hello all, I'm having an issue, which I found is quite common (nevertheless, I haven't found an answer for it). Basically, I'm trying to add new rows (5 new rows, to be specific) on top of a table I previously created and formatted. When I try to insert new rows, Excel crashes and gives me...

I have a template Excel file with multiple sheets. Each sheet is Protected (for formula-based cells & graphs), with unprotected areas to enter data. Each sheet has some "dummy" data loaded in the unprotected areas as a reference for users. Users are having an issue whereby if they delete the...

Excel 2007 <tbody> Row\Col A B C D E F G H 1 Inventory Value Report 2 3 4 5 6 Formula: Item Description Category UOM Qty Unit Cost Extended Value 7 KIT, OVERHAUL, 22 ITEMS PER KIT, OVERHAUL KIT 10000 HOUR ( COMPRESSOR ) SPARE...

I've been investigating this problem for over a day now and it's infuriating. I have a 'Summary' sheet that performs a loop whereby it it opens a workbook, copies a small range of cells and pastes them into the summary. I made some alterations and now Excel crashes on the 2nd loop or 3rd...

I've dug and dug and dug online to try and solve this before coming here, so I hope someone can help me. I have really simple vba in this report to auto apply a couple of filters to the data by clicking a button. At some point, something happened that made it so when I opened the file, I could...

Recently installed Office 2016 in Windows 8.1. With multiple XL files open, when closing a single file without saving, the program crashes without exception. I have the following add-ons active: - securisync office plugin . send to bluetooth Looking forward to any suggestions. Drives me crazy...

Hi. I have a complex userform. I've run into a problem where pressing the either of the enter keys (the one on the number pad and/or the one by the letter keys) causes excel to crash & close. I've tried using an onkey command to disable the enter keys as in this post...

I’m writing about a subject I’m sure you’ve dealt with hundreds more times than I have: Excel crashing. What’s going on is that during certain operations as it runs, Excel crashes with the restart/debug dialog box. Here’s the thing: it happens predictably in two different places – two specific...

Hello! I have been successfully running a code for a while now but I just added an extra few lines which does a little bit extra copying and pasting some numbers... for some reason if this part of the code is executed, all my open workbooks are closed! I have Googled this problem and found...

Hi, my VBA script has run for many years with small changes, none recently, and only now I found Excel crashing when running certain operations. It always crashes with no error message when trying to copy a worksheet. Code excerpt of all lines that contain the sheet: ... Public shtModel As...

Hello fellow Excel guys, I'm a developer for my company, and we use a shared workbook which is accessed by several people through the day. It relies heavily on VBA (so much so that I have separated out the code into an .xlam add-in which is referenced from the main file, in order to keep the...

Hello all, This is a problem I think I've encountered before but cannot remember the solution to. Situation: I have three text boxes in a Frame, on a form. The user enters date values in each text box and clicks a button. The code is supposed to check the entered text, swap out "." for "/"...

Hi, Excel 2013 crashes when running macro. same macro is working fine in excel 2010/2007. there is no addi-in are enabled in excdel. also it does not crash when step-in through lines. Kindly help!!.. it's making impossible even testing macro. Vimal