An 'average' relatively new 3-4 year old 'business' computer with at least 8GB of RAM should be able to handle the scenario you describe. Without looking atģ00KB per workbook is relatively small, easy enough to handle multiple workbooks. Your specific use and application of functions will affect performance. Trying to make recommendations in-the-blind is a losing game. You can often replace INDIRECT with a SEQUENCE construction, for example:Īre you having a specific problem? Try it on multiple machines. Limited by available memory (default is 1 sheet) Workbook size is limited only by available memory and system resources.

A data model’s share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded.Ħ4-bit environment imposes no hard limits on file size. Limited by available memory and system resourcesģ2-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. But Microsoft states the following limits: Indirect used intensively as means to minimize formula maintenanceĬustomer pain point mentioned in not pertinent

Macros are built-in (Get.Cell, Get.Workbook ) Number of sheets in each workbook is limited to 3Įach sheet has 1 Table of 10 columns 20o rows Number of open workbooks (Excel 365 xlsm) limited to 5 Hello, if there is heads up on following situation, much appreciated!

Microsoft excel 2011 multithread