ATTENTION

This FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices.


flexsim.com

Go Back   FlexSim Community Forum > FlexSim Software > Tips and Tricks
Downloads

Tips and Tricks Share helpful modeling ideas

  #1  
Old 01-06-2010
Nico Zahn's Avatar
Nico Zahn Nico Zahn is offline
Flexsim User
 
Join Date: Sep 2007
Location: Bingen am Rhein, Germany
Posts: 179
Downloads: 19
Uploads: 4
Thanks: 66
Thanked 60 Times in 32 Posts
Rep Power: 201
Nico Zahn has a spectacular aura aboutNico Zahn has a spectacular aura about
Default Speeding up Excel Export

Hi,
if you have Excelexports which export to Worksheets with a lot of calculation and a lot of Diagramms you can speed up your Excelexport by switching of the Screenupdate and the Calculation in Excel.
You can do this by the VBA in Excel. Open your Excel template and press ALT+F11. Choose your Workbook and Open in then two dropdownboxes above the code window (see picture attached) and add the following code.

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
End Sub

This will turn off the Screenupdating and the Calculation.
This will only speed up the export if Excel has to calculate or draw diagramms during your Export from Flexsim.
Attched is a sample Excel file with the VBA Code.
Attached Thumbnails
Click image for larger version
Name:	Excel_sample.JPG
Views:	272
Size:	170.7 KB
ID:	888  
Attached Files
File Type: zip Export_sample.zip (12.1 KB, 249 views)
__________________
kind regards Nico.
The Following 9 Users Say Thank You to Nico Zahn For This Useful Post:
Tom David (01-06-2010)


Thread Thread Starter Forum Replies Last Post
Sketchup Pro Export Settings Joshua Cole Q&A 7 03-15-2011 10:08 AM
statistics cannot export to excel or csv zhang xin Container Terminal (CT) Library 2 03-12-2010 08:01 AM
Excel 2002 vs. Excel 2007 Nico Zahn Q&A 2 04-27-2009 01:47 AM
Visio Export to FlexSim Jon Fournier User Development 0 06-25-2008 07:29 PM
Recorder automatic export Stephanie Giovannini Q&A 3 03-19-2008 04:52 PM


All times are GMT -6.
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Copyright 1993-2018 FlexSim Software Products, Inc.