slow refresh times in excel 2007 for workbooks with user-defined functions

VAndre

New Member
Joined
Dec 7, 2005
Messages
42
I have a couple of workbooks that use VBA functions. They have worked well in Excel2003 environments, but refresh time is very slow once I migrated to Excel2007. The speed is so slow that there is a visible series of blinks every time I refresh. It's really bad (I literally got a migraine the first day I spent a lot of time with one of these workbooks).

Has anyone seen some literature regarding what is going on here?

Keywords: Flashing Blinking slow refresh recalculation speed Excel 2007 flicker
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,362
Office Version
365
Platform
Windows
Keywords : Post the code, and an explanation of what it's meant to do.

As far as I know a UDF should not be doing what you describe in any version of Excel.:)
 

VAndre

New Member
Joined
Dec 7, 2005
Messages
42
you guys sure are quick.
some of these items of code are simple calculations

examples are things like:

Code:
Function Factorial(n) As Double
    Dim rep As Double
    Dim i As Double

    rep = 1
    For i = 1 To n
        rep = rep * i
    Next i

    Factorial = rep

End Function
There are also a couple of simple command buttons. In all cases there are no screenupdating or such going on. also not selecting different worksheets.

Both of the workbooks I'm dealing with were pretty fast in 2003.
 
Last edited:

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,362
Office Version
365
Platform
Windows
You do know there is an Excel worksheet function called FACT.

Screen updating etc shouldn't be an issue with a UDF because you probably shouldn't be using a UDF to alter values, format otters etc.

A UDF in Excel VBA is normally used to do some calculation(s) and return a value to a cell.:)

I think there might be something else going on, whatever that might be could be something to do with the version thing but then again it might not.:eek:
 

VAndre

New Member
Joined
Dec 7, 2005
Messages
42
yeah, I inherited this workbook and there are a lot of old functions like that in there... dozens of them.

It's a strange problem that a few people I know have seen
 

Forum statistics

Threads
1,082,287
Messages
5,364,299
Members
400,787
Latest member
bs04c

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top