crash

Hi, I have a VBA program that has multiple modules and basically it starts a userform on workbook_open event. Then it goes to a log on screen in the userform. Once a userlogs in the code checks credentials against database to make sure its legit then it goes through a subroutine which basically...

Desperate: My excel crashed. I rebooted, and downloaded a backup copy of it. Now when i open it, it says: "SECURITY WARNING some active content has been disabled. Click for more details." I instead Enable Content, and when it does so, most features are grayed out, including saving it and even...

When Hook The Window Class #32770 Through Form , It Does Work Fine But When SubClass This Window Inside CBTProc , System Crash And Hang Up , What s Wrong ? Because Of Not Define Handle Window MayBe Happens Crashing ? In Access Application When Open Form And Hook Window Class #32770 , Again...

Hello, this has been an on-going issue but now it's getting out of hand. My excel crashes, I can't close it from the taskbar nor can I CTRL, ALT & DEL, so have to power down. Usually I've got 6-7 spreadsheets open working on a 3 screen setup. Since last night, I tried a few different ways...

Hi, I have a Userform which opens as "vbModeless," it contains a series of buttons to open more Userforms that all open as "vbModeless." Very simple, but randomly some of the files will immediately close when selecting one of the buttons contained on the first opened form. If I remove the...

I am using Excel 2016 on my work computer and we have a shared file that my boss and I have created. Yesterday, the macro was working fine and you could open it and make changes to it but since then if you try to open the macro it crashes excel. I can open macros and edit them on all other excel...

I have a module called UpdateCheck with procedures which check another document to see if the version number has changed. If it has, it asks the user if they want to update the document to the new version. This is only to update the modules because the formatting of the worksheets is set in...

Howdy, I have been running a number of processes at my company for years now (many were made possible from contributions from this community - thank you). I now have a new issue with files crashing Excel when loading into memory. The trouble is, it's not every file and its not every time. I...

Hi, I've got a macro that basically does the following: Opens data source files, that remain open (aprox. 8 files) Get a key from a list for filtering out data in the source files Copies result for and pastes in corresponding sheet in macro file Refreshes pivot tables and charts to export...

Our office is experiencing an issue where Excel will crash if a user does not save a Macro-enabled workbook that they opened. No error message is given. Is anyone else experiencing this issue? Is there anything I can do to troubleshoot what the issue is? Thank you in advance for any help.

Hi All, After some hours of investigation, I found a Excel crash issue under this conditions: 1. on VBA you use a calculation only on some rows or columns 2. you have pivot table in same sheet => this makes Excel crash when you save or change sheet. Hope this information will be usefull for you all.

Every time I need to create a pivot chart and I start customizing the colors on the filters, excel will inevitably crash and restart itself - sometimes offering a repaired version of my excel file. Most times it just reopens wherever i last saved any updates. Why is the chart customization...

Hi, have anybody experienced where their Excel version's Get & Transform is unresponsive? I have created a file and done some queries etc just to have it crash and now it does not even recognise that I had a query. Thank you.

Hi, I have a workbook with 12 worksheets. I can access all of them except for 1. if I click on it excel will automatically crash (can't rightclick, can't evene xecute via VBA) --> always a crash. What i've tried so far: 1) open and repair... not it. 2) neither the sheet nor the workbook...

Hi All, I've built a workbook that calculates OTIF for our orders for work. The issue I have is the workbook now contains so much data, excel hangs when refreshing and unless I leave it for 30mins, it crashes. I want to know if it's possible to have a VBA that runs, so it refreshes the data...

i swear ive been having odd excel issues.. when i USE screenupdating = true....it prevented the macros from crashing, but when I used FALSE...it crashes at the end of the macro odd, i thought not showing screenupdating would NOT cause it crash

Hi all, New forum member, I found that this forum is excellent for questions and troubleshooting. I'm working on a previous edited workbook for my job. Using Excel 2016, I had recently converted the designated worksheet into a table. It was previously not in table format. The sheet has...

I've got a weird problem. I have an XLSM file (with some VBA) that works fine 95% of the time. The other 5%, it crashes on opening, and then will continue to crash on opening - until I open and save the file with a different version of Excel (2016-32bit). Anyone ever resolve this issue? Even...

Once in 3 or 4 code runs, excel is crashed with that strange, tough error message about Error in data connection (can’t connect). Code is extremely simple (crashed at the last line): Set wsS = Target.Parent Set rng = wsS.Range("B3:F186") Set d = wsS.Range("G3") rng.Copy d.Insert...

Hi, I have been having this problem for quite some time. My IT folks have upgrade my Microsoft office to 2016... however, the problem still happens. Randomly when I copy a cell the boarder no longer appears... I have found this to be an indicator that my excel is going to crash --- or "stop...