excel 2016 sheet 2 super slow& crashes often

Hidde663 / My first build
September 5, 2018 at 03:13:28
Specs: Windows 10 Pro 64bit, i5-6600K[delid]@4.8GHz/4.3GHz@1.4v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-28 1T 2700MHz@1.35v
a college of mine got an excel workbook with 2 sheets
sheet one responds really fast, but when i switch to sheet to i get 30% cpu usage (so 1 core at 100% & a 2nd one for handingling background tasks)

ive tried copieng the content to another workbook, but excel always crashes before i can do anything.

is there any way i can look for this infinite loop with a debugger of some sort?
or should i copy text cell by cell to another sheet?

P.S.:

I can acces VBA, but there is no code there.
I can open sheet 2, but all i can do is scroll slowly & select cells, anything else will crash excel.

also the page only contains text & figures (circles, squares, etc.) from A 1 till CA 64

i5-6600K[delid]@4.8GHz/4.3GHz@1.4v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-28 1T 2700MHz@1.35v
MSI Armor RX 570 4GB@1340Mhz core@1.110v/1865MHz BiosModded


See More: excel 2016 sheet 2 super slow& crashes often

Reply ↓  Report •

#1
September 5, 2018 at 06:18:41
Just tossing some stuff out...I know that a corrupt workbook can be very frustrating.

re: "a college of mine got an excel workbook with 2 sheets"

Do you mean (s)he "got" it from someone else or that (s)he has an Excel workbook?

If she got it from someone else (s)he might want to check with that person to see if they are having problems or maybe get a another copy to see what happens.

Did you try making a copy of the workbook to see if the corruption follows?

Did you try opening the file on another computer?

re: "ive tried copieng the content to another workbook, but excel always crashes before i can do anything."

Did you try copying the entire sheet to another workbook? (Right click the sheet tab, choose Move or Copy, click the drop-down, choose (new book))

re: "also the page only contains text & figures (circles, squares, etc.) from A 1 till CA 64"

Try cutting or deleting the shapes via F5:

You could try deleting the shapes or at least selecting them all to see if anything strange shows up. Press F5, click "Special", click Objects, click OK. All shapes and objects should selected. You could delete them or Cut/Paste them to another sheet or workbook.

(I once had a workbook that somehow ended up with hundreds of little shapes in it, so small that you couldn't even see them. Depending on where you clicked you either selected a cell or saw 2 little "selection dots" indicating that you had selected a shape.)

re: "also the page only contains text & figures (circles, squares, etc.) from A 1 till CA 64"

Open the corrupt workbook and a new workbook . Select A1 in the new workbook, type = and then click in A1 of the corrupt workbook, hit enter. If you need to, delete the $ so that it shows something like this:

='[workbook_name.xls]Sheet_name'!A1

Drag this down and across as far as you need. Select the entire range, Right-Click...Copy...Right-Click...PasteSpecial...Values

Hopefully only the text will be brought over, not the corruption. If referencing/"copying" the entire sheet in this manner doesn't help, try breaking the sheet down, referencing maybe half or 1 column at a time, etc. Keep adding more until the corruption shows up. I've used this method to narrow corruption down to a single cell. Once I found that cell, I deleted the entire cell, inserted a new one in its place and the problem was solved. Since you said that the sheet only contains text and shapes, you shouldn't run into any cell reference issues when you delete the cell.

That's all I have for now. Good luck!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

#2
September 5, 2018 at 08:23:53
I've done it all & nothing worked, so i did the ctrl+a, del

got an empty sheet nog, still lagging.

I will attempt to move everything over one by one, to another sheet, hoping it wont crash.

will safe like 2 hours worth of work if i can fix it.

anyways thanks for the suggestions, the F5 trick i did not know about, will be using that from now on.

I'll report back tommorow & tell you if i managed to safe the sheet :D

i5-6600K[delid]@4.8GHz/4.3GHz@1.4v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-28 1T 2700MHz@1.35v
MSI Armor RX 570 4GB@1340Mhz core@1.110v/1865MHz BiosModded


Reply ↓  Report •

#3
September 5, 2018 at 10:02:10
Not sure it will be of any help, but try turning off Automatic Calculation, in the workbook.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

Related Solutions

#4
September 5, 2018 at 10:20:12
You might also want to try starting Excel in Safe Mode:

In Windows,
select Run
In the Run box enter: EXCEL /SAFE

When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. However, COM add-ins are excluded.

To check if you have any COM add-ins running:

In Excel
Select File
Options
Add-ins.

At the bottom change the Manage dropdown box to COM add-ins,
and select Go.
If you have any COM files, Clear the checkbox

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#5
September 5, 2018 at 10:41:19
thanks will try both tommorow

i5-6600K[delid]@4.8GHz/4.3GHz@1.4v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-28 1T 2700MHz@1.35v
MSI Armor RX 570 4GB@1340Mhz core@1.110v/1865MHz BiosModded


Reply ↓  Report •

#6
September 6, 2018 at 03:33:33
i tried all 3 options, cpu usage does drop down to around 5%, but as soon as i start scrolling or clicking on cells, cpu utilization jumps to 100% for 1 core.

Im kind off lost at this point and probably so are you guys, I'll start moving stuff over piece by piece.

if that doesnt work, ill tell my college to just remake the sheet, I mean he can just type it over.
there are no formulas on the sheet anyways

i5-6600K[delid]@4.8GHz/4.3GHz@1.4v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-28 1T 2700MHz@1.35v
MSI Armor RX 570 4GB@1340Mhz core@1.110v/1865MHz BiosModded


Reply ↓  Report •

#7
September 6, 2018 at 09:56:03
Have you tried saving the sheet as a .csv file?

Delete the good sheet and save the offensive sheet as .csv.

Close it, open it and if it "works" thern select the data and Copy/Paste it to a new worksheet in the original book.

Then maybe you can use the F5 feature to copy the shapes over from the original sheet. If the problem comes back with the shapes, start narrowing it down.


How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

Ask Question