slow

Can anyone help please, I have just added a picture vlookup into by spreadsheet that has now made the spreadsheet run so slow, some times I am waiting up to 15 seconds to move the cursor around the spread sheet. I have in 2 of my 20 or so VBA codes added the following, which did help speed it...

Hi, I'm trying out Solver and it's very very slow! My test spreadsheet has 25 rows of test data and it ran over 30 minutes and froze all the other Excel screens, so I finally ended the task. It probably would've ran for 2 hours if I let it. Part of the issue is, the constraint is set to...

I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a

Hello Mr. Excel Team Members, I have an issue with a Gantt Chart Template that I create, something it makes it extremely slow... I'm not sure if its due the formulas, conditional formatting or other stuff... Could you please take a look of it and support me to speed it up? Thanks a lot...

I set listbox items to load picture in the picture box. Selecting an item in listbox is slow, the higher the size of the jpg file, the longer it takes to load, which do not give room to select another item quickly. is there any solution to this?

Does anyone know how to speed up an excel file? I have a lot of data that is running with several formulas, but I don't feel it should be this slow. I have other documents with more info that doesn't run this slow...

Sometimes I get an error when getting data from the web. (Either due to lost internet connection or slow internet connections.) The error occurs on Send. if, for example, the website can not be reached, lost internet, or slow internet, I would like to give a message to each scenario. How can I...

We have a N/w of 3 computers. The Access prog is on one computer and is accessed by the other 2 computers. The Appl. runs well on the comp. on which it is installed. But it is slow on the computer accessing it. What can be done for this?

Workbook with 3 sheets: Timesheet, Charts, Data. ONLY the Timesheet when I enter a number or time, calculation is slow (~5-6 secs). It does not happen with alpha characters. Dimension for Timesheet is A1:AG566 A few vlookups and many if statements. The thing that puzzles me is this happened...

This one is throwing me for a loop (apologies for the pun...please still help me!). I'm confused about this one. Here's what the macro does, high level. Opens a template workbook. Saves a copy of the template workbook as a temp file. Loops through a list of other "original" workbooks: One at...

Hello, I have the following question: I have created 6 queries with a lot of data. The data is from SAP. (Methode: data - from file - from workbook). The excelsheet has become very slow. I use the data to create a financial overview of all scientific reports. I use one worksheet for a report...

HI I have been given a data extract, and due to the criteria I have, the formula based on all of those finally works. However, it is very heavy and slow - Calculating (4 Threads): XX% The formula is as follows...

Hello again! I have the following disabled: Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.EnableEvents = False and my macro is doing the following to the active sheet: Cells.Replace What:=Existing_Workbook_Name, Replacement:=New_Workbook_Name...

I have a quite small database put on my companies network shared drives. The database is split into two files. The connection is set to IPADRESS\FILEPATH. I have huge problems that the database is very very slow when users works in it. I have searched for a long time for an answer to this, but...

My spreadsheet is slow to add a new line through a macro, how could I speed it up?

Hey, I have a Conditional Formatting running on my excel sheet which will run slow at times, especially when applied to larger range such as $A$1:$z$1000, however if fewer cells are chosen the same conditional formatting will run perfectly. therefore I was wondering if a Vba could set...

Greetings, I have a workbook that is very very slow to open. The details: The workbook is very similar in structure to other workbooks that don't share this "slow to open" issue. The workbook has quite a few formulas built into the sheet. Not sure how to proceed...:eeek:

Good day Everyone Hope the week is treating everyone well so far. I have a VBA code for a user form that is running extremely slow. The code is as follows: Private Sub cmdaddentry_Click() Dim Rowcount As Long Dim ctl As Control If Me.txtshift.Value = "" Then MsgBox "Please enter...

Hi, I'm new here. This is the situation: In my office I have 2 pc with very similar configuration. 16 GB ram and similar CPU (I7 4790 vs I7 6700). When I try to update, or simply put or remove a filter on a column the performance is very different. For example, If I insert a filter on a column...

What is the best excel function or functions to look up a value from a different worksheet (workbook B) with three criteria without suffering from slow Excel spreadsheet and be able to close the workbook B when I don’t have to work on it. <tbody> Excel Function Tried Advantage...