Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Solved
Excel Multi Threading and Manual formulas VB Script
Posted on 2016-08-08
HI
I want to be able to create a XLAM file using Vbscript that will do 2 things
1 = Set formula calculation to manual and calculate before save to True
2 = Disable Multi thread calculation
I can get the disable multi thread calc to work using this script and placing he xlam file in the XLStart
Private Sub Workbook_Open()
' Disable MultiThreaded Calculation '
Application.MultiThreadedC
' Other options '
' Automatic Mode '
' Application.MultiThreadedC
' Manual Mode '
' Application.MultiThreadedC
' Use 2 CPU '
' Application.MultiThreadedC
End Sub
But when I try to add in the manual formula part using this script it does not work
Application.Calculation = xlManual
Application.CalculateBefor
Can you help me as I am not at all good with VB script
Thanks Marcus
I want to be able to create a XLAM file using Vbscript that will do 2 things
1 = Set formula calculation to manual and calculate before save to True
2 = Disable Multi thread calculation
I can get the disable multi thread calc to work using this script and placing he xlam file in the XLStart
Private Sub Workbook_Open()
' Disable MultiThreaded Calculation '
Application.MultiThreadedC
' Other options '
' Automatic Mode '
' Application.MultiThreadedC
' Manual Mode '
' Application.MultiThreadedC
' Use 2 CPU '
' Application.MultiThreadedC
End Sub
But when I try to add in the manual formula part using this script it does not work
Application.Calculation = xlManual
Application.CalculateBefor
Can you help me as I am not at all good with VB script
Thanks Marcus
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2 Comments
Active 3 days ago
Try doing it before you disable multi thread calcs
Private Sub Workbook_Open()
Application.Calculation = xlManual
Application.CalculateBeforeSave = True
' Disable MultiThreaded Calculation '
Application.MultiThreadedCalculation.Enabled = False
....
End Sub
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Script to copy or move mouse-selected collection of files plus targets referenced by shortcuts (.lnk)
The purpose of this article is to help illuminate the real challenges and options available (where they may exist) for utilizing simple scriptin…
Welcome back! My apologies for taking so long to write part two of this series; it's been a long time coming! As I promised in Part 1, this article will focus on how to locate those elusive AD properties that you are searching for. Why is this us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month9 days, 5 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.