Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by duncanb7
at 2024-03-23 07:46:36
ModifyPoint:500 Replies:7 POST_ID:828448USER_ID:11059
Topic:
Hypertext Markup Language (HTML);Visual Basic Programming;Microsoft Excel Spreadsheet Software
I would like to have a good example website to show how it will have code speed advantage
for Application.Calculation = xlCalculationManual and Application.Calculation = xlCalculationAutomatic
I know those functionality but I wonder what situation we will use it individually for speed ?
Aud during file save, Is it all formula in Excel sheet will be updated even I set it xlCalculationManual ?
Please advise
Thanks
Duncan l
for Application.Calculation = xlCalculationManual and Application.Calculation = xlCalculationAutomatic
I know those functionality but I wonder what situation we will use it individually for speed ?
Aud during file save, Is it all formula in Excel sheet will be updated even I set it xlCalculationManual ?
Please advise
Thanks
Duncan l
Author: duncanb7 replied at 2024-03-26 06:13:35
>> In what situation, Application.CalculateBeforeSave = False,is good for speed optimization ?
As I mentioned before, it would really make a difference if you have a file with huge volume of data and a lot of formulas. It really differs from sheet to sheet. Say for example, more than 1000 rows of data and 3 columns have formulas in it...so there are 3 * 1000 = 3000 formulas that excel needs to calculate would obivously slow down editing the spreadsheet.
but without looking at the data, you need to make an educated guess on it...
Accepted Solution
Expert: pari123 replied at 2024-03-25 12:29:42
500 points GOOD
>> In what situation, Application.CalculateBeforeSave = False,is good for speed optimization ?
As I mentioned before, it would really make a difference if you have a file with huge volume of data and a lot of formulas. It really differs from sheet to sheet. Say for example, more than 1000 rows of data and 3 columns have formulas in it...so there are 3 * 1000 = 3000 formulas that excel needs to calculate would obivously slow down editing the spreadsheet.
but without looking at the data, you need to make an educated guess on it...
Author: duncanb7 replied at 2024-03-25 12:21:08
Dear pari123,
Thanks for your suggestion ?
But my question, even I don't know
In what situation, xlcalcaulteManual is good for speed optimization ? or what Is said above is correct
(THe function might be good when you are doing a VB code debugging or doing a code for sepcifiy sheet from that you
don't want to recaulate other sheets since other sheets value is not important at this moment )
In what situation, Application.CalculateBeforeSave = False,is good for speed optimization ?
Thanks for your suggestion ?
But my question, even I don't know
In what situation, xlcalcaulteManual is good for speed optimization ? or what Is said above is correct
(THe function might be good when you are doing a VB code debugging or doing a code for sepcifiy sheet from that you
don't want to recaulate other sheets since other sheets value is not important at this moment )
In what situation, Application.CalculateBeforeSave = False,is good for speed optimization ?
Expert: pari123 replied at 2024-03-25 12:11:53
Hi Duncan,
If you use the following code -
If you use the following code -
Private Sub Workbook_Open()Application.Calculation = xlCalculationManualApplication.CalculateBeforeSave = FalseEnd Sub 1:2:3:4:5:
then this doesn't recalculate while saving.
Application.CalculateBeforeSave = Values are True or False. If calculation is Manual and CalculateBeforeSave is true when you Save the workbook it will be recalculated.
Author: duncanb7 replied at 2024-03-25 11:55:53
If recaulation before save ,So it might not help me if my VBA code needs to do open file and save file for automation looping 100 files.
THe function might be good when you are doing a VB code debugging or doing a code for sepcifiy sheet from that you
don't want to recaulate other sheets since other sheets value is not important at this moment
AM i right ?
Please advise
Duncan
THe function might be good when you are doing a VB code debugging or doing a code for sepcifiy sheet from that you
don't want to recaulate other sheets since other sheets value is not important at this moment
AM i right ?
Please advise
Duncan
Expert: Saqib Husain, Syed replied at 2024-03-23 12:25:39
I think formulas are recalculated before save
Saqib
Saqib
Expert: pari123 replied at 2024-03-23 08:15:17
Hi,
if you search in experts-exchange, you can find good articles about this. THere is also a write-up on C Pearson's site.
Here's the link - http://www.cpearson.com/excel/optimize.htm
From my experience, the advantage to set it xlCalculationManual is if when your data is huge and there are a lot of formulas.
If the xlCalculationManual is set to manual, it won't update on file save.
Let me know if you need any further clarifications,
Thanks,
Ardhendu
if you search in experts-exchange, you can find good articles about this. THere is also a write-up on C Pearson's site.
Here's the link - http://www.cpearson.com/excel/optimize.htm
From my experience, the advantage to set it xlCalculationManual is if when your data is huge and there are a lot of formulas.
If the xlCalculationManual is set to manual, it won't update on file save.
Let me know if you need any further clarifications,
Thanks,
Ardhendu
