Excel FAQ - Excel Application and Files. Menu: Frequently Asked Questions about Microsoft Excel 1. Start Excel, Open and Close Files When I start Excel, why do a million files open up automatically? Prevent files from opening automatically in Excel 2007 and Excel 2010: To stop files automatically open in Excel 2007 and Excel 2010, you can remove a folder name in the Excel options: Click the Office Button, then click Excel Options (In Excel 2010, click the File tab, then click Options) Click the Advanced category, and scroll down to the General section.
In the box for 'At startup, open all files in', you might see the name of a folder, and its path Clear the folder information from that box (or go to that folder and remove the unwanted files). Check the XLSTARTUP Folders If there was nothing listed in the Startup box, the unwanted files might have been accidentally saved to one of the XLSTART folders. Choose Tools > Options and select the General tab. An add-in with a programming error is causing problems. 2. New Tab. Excel Memory Limits - Decision Models. If you work with large workbooks, external data or charts sooner or later you will get one of the dreaded messages “Out of Memory” or "Excel cannot complete this task with available resources" or "Not enough System Resources/Memory to Display Completely" , regardless of how much RAM or how big a swap-file you have.
This is because Excel has its own memory manager and its own memory limits. The amount of memory a workbook is using has no effect on Excel calculation speed, which in fact depends mainly on the number of formulae and the number of cells calculated/referenced by each formulae. Note that Excel 2003, Excel 2007 and Excel 2010 will allow you to make effective use of much more RAM than previous versions. Excel's memory manager in Excel 95, 97, 2000, 2002 and 2003 does not make use of all available RAM or virtual memory, regardless of the Windows operating system being used (Win95/Win98/Win ME or Win NT4/Win 2000/Win XP/Vista). Memory Limits by Excel Version VBA Memory Limits. Make Dynamic Dashboards using Excel 2010 [Video Tutorial & FREE Download Workbook. Posted on December 8th, 2010 in Charts and Graphs , Pivot Tables & Charts - 55 comments Do you know that Excel 2010 makes creation of dynamic dashboards very simple?
Yes, that is right. Using slicers feature, you can create dynamic excel dashboards from your data in very little time. Today we are going to learn a technique that will help you create a dashboard like below. (Note: The technique works only Excel 2010 or above.) [View the dashboard image in large size] How to make a Dynamic Dashboard in Excel using Pivot Tables & Slicers I made a short (12 min) video tutorial explaining the concept and construction of this dynamic dashboard. [Watch the dynamic dashboard tutorial on YouTube] If you are new to Pivot Tables, Read this excellent pivot tables tutorial & watch the video on pivot tables.
Download Dynamic Dashboard Workbook: Click here to download the Excel 2010 workbook. Do you use Slicers? I have been using Excel 2010 for the last several months. What about you? More awesome tips for you: Excel project management executive dashboard template - free ebook downloads.