freezing

Hi Team, I have an Excel template which itemises a list of items. The numbering of each item is what makes this task particularly challenging. Depending on the column that the item is sitting in determines the numbering increment. A picture is worth 1000 words so I'll show the general gist of...

Hello, i have a code that is displaying the last changed cell of a range. It works for a few tests but then randomly will freeze up my workbook. Any help would be great, also im looking to make this apply to all worksheets in the workbook, if anyone has any direction on that it would be helpful...

Any idea why these lines of code would be causing my computer to lag and the excel sheet to freeze when closing the sheet? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim f As Long Dim j As Integer For f = 1 To Rows.Count If Cells(f, 1).Interior.ColorIndex = 37 Then...

The Worksheet names that I have make the tabs wide enough that five tabs show at any given time when scrolling through the twelve Worksheets in my Workbook. I would like one of the Worksheet tabs to be seen at all times, preferably the right most of the five tabs that can be seen. Essentially...

Hello All I have a very large excel file with 7 million records and 45 MB in size and on doing any action like deleting column, my excel is freezing and it takes a long time to complete that action. Is there any way to make these actions on excel quicker. Thanks in Advance.

Hello We use Excel 2106 via office 365. We have had countless issue with excel freezing. We have tried a lot of things and nothing seems to really fix it. The freezing isn't consistent, they happen when moving from cell to cell or saving, etc. We have turned off annual updates and went to...

Hi, I have a workbook which is running very slow in just one worksheet. It is almost unworkable. I cannot scroll, the page constantly freezes and occasionally the workbook crashes. When it does work I can use the other worksheets without any issue. The worksheet in question has a lot of...

Hi, I have a large Word file (around 7 MB, 2000 pages) which I update everyday for work. I have used this file and updated it in Word without issues for many years until now. Since the last 2 weeks Word keeps going 'not responding' for a long time when I try to do anything with it (scroll...

Greetings, Context: I have three tables (formatted as tables) with the same data going into them. Each table has different formulas for calculating different things. Duplicates from each table are removed differently, to accommodate different reports, which is why there are three (in case you...

I have a macro splitting multiplte sheet depending on coloumn (A) in all the sheets and freezing top 2 rows while runnig the macro error reflecting Runtime Error 1004 Cannot rename a sheet to the same name as another and the macro not executing can it be done to flexible with freezing the...

Periodically (but quite regularly) when I try to open a user-form it will open up but be blank. If I click the Esc key the form will fill but from that point onward (to click buttons or close the form) I must click the Esc key again before it will accept each action. Also, if I have VBE open...

Hey all, I have this strange issue with some of my Excel files. Whenever I try to print from excel, it will lock up when selecting the "Print" section under "File." Once it's at the printer settings, it will say "Looking for printers" at the printer selection menu and the entire excel sheet...

Please help me if someone can help me. I have one excel file, the file property around 500kb. whenever i tried to open more than one file its got freezing, not responding anything but still i can save and close all workbook. its happening only if i open specific file (Salary Payroll). I tried...

Hey guys, I am using the below macro and whenever i try to delete or add a row or column it takes longer than normal, like it is having to think about it, and when I run the macro the entire workbook freezes and after waiting 5+ mins i have to force close excel. Now the workbook I am using has...

Hello All! This has been bothering me for a while. I work with many large, data-heavy models. Many times I need to paste in values from outside files into these models to keep them up-to-date. When pasting values into these models, some function perfectly fine when the Workbook Calculation is...

<article> I am using Excel 2013 and have the issue of Excel keeping on freezing/hanging when working with a sheet that has more than say a thousand rows of information. The current spreadsheet I have problems with works with is populated by 36,475 rows of information across a...

Hello all, I have a workbook with several formulas in it that link to a program called Prosystem Tax. The formulas look something like this: =WinFx|'11948,1'!'4,N,-1' There are a lot of times when I open the workbook and enable links that excel will freeze and ultimately crash. The only...

Hello, I have a very large excel file with around 30 million cells, with approximately 2 - 3 million of those cells being formulas. The file is about 250mb. When doing a sort, adding or deleting columns, or pasting formulas, Excel either can take around 5 - 10 minutes to complete the task, or...

Hi everyone! Thanks for checking into my issue and I appreciate any responses I'll get. I have a database that has thousands of cells that I need to find/replace monthly because the formula needs to reference the correct month's data folder from another workbook every month. My issue is that...

I support a company that is having Excel 2010 issues. A few users are having issues with the Menus "graying" out they can edit the workbook but cannot use any of the menu items. They are accessing the XLSX files over a network share