Question about Microsoft Office Standard for PC

1 Answer

Consolidation I am trying to get a consolidated report of about 15 to 25 Individual Excel Workbooks, whereby I can just delete unwanted wkbks and add new wkbks and get the report. I made a pivot table but it is only restricted to its original wkbks, unless I open the pivot table and manually change the references ... would really appreciate if I found a solution to this.

Posted by on

1 Answer

Re: Consolidation

There is an easier way. in your workbook with the worksheets to consolidate, insert a new blank sheet. from the DATA menu, select consolidate. click ADD and go to the first sheet, select the required information (best to select all headings aswell). Continue this procedure for each sheet. at the bottom of the Consolidate dialog box, check all three options for links. and click OK. This should now give you a consolidation of all your sheets.

Hope this solves your problem

Posted on Nov 03, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Memory is used up by excel

I don't think you can. It's a real resource hog especially if youre using 2010/13. See below.

Excel 2003 is officially limited to 1 Gigabyte (GB) of memory.
This limit appears to be a limit on the working set memory used by the Excel process, which is the memory reported by Windows Task Manager.
Although Excel 2003 has a substantially increased memory capacity, many of the individual specific memory limits listed below have not changed in Excel 2003.

Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under Windows XP/Vista (Windows memory limit).
This 2 Gigabyte limit is a limit on the Virtual Memory address space. Virtual memory used by a process is larger than the working set memory reported by Windows Task Manager, so the amount of useable memory under Excel 2007 is considerably less than twice that of Excel 2003.
Because Excel 2007 (Excel12) also requires more memory to store the indexes to the increased number of rows and columns you may not be able to load larger workbooks under Excel 2007 than was possible under Excel 2003. Memory Fragmentation may also mean that it is difficult to make use of all of the available 2 GB of virtual memory.

Many of the individual memory limits listed below have been removed in Excel 2007.

Excel 2010 is available in 2 versions: 32-bit (2 Gigabytes of virtual memory) and 64-bit (8-Terabytes (which is 8000 Gigabytes of virtual memory)).
The 32-bit version has the same memory limits as Excel 2007, but the 64-bit version, when used with a 64-bit Windows operating system, will have extremely large memory limits.
Note that the different versions of Windows Vista 64-bit and Windows 7 64-bit support differing amounts of RAM.

Aug 17, 2014 | Microsoft Excel for PC

1 Answer

What is microsoft excel and its use

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs. Microsoft Excel is comprised of organizational units called workbooks.

Jan 20, 2013 | Microsoft Excel for PC

3 Answers

Print preview makes excel 2007 stop working

The Smart Technologies Notebook Version 11 software certainly seems to be the culprit. Taking the cue from Bob Cochran, this is what is what I did and the problem has stopped. Open Excel and click on the Office button at the top left. Then Click on Excel options. Click on Add-ins. In the "Manage" window, select COM Add-ins and click Go. In the COM Add-ins window uncheck SMARTInk-Excel-All and click OK and "poof" problem gone!!!

Aug 21, 2012 | Microsoft Office Professional 2007 Full...

1 Answer

Merging problem

Use the Help function in excel and search for "Consolidate". This will show you how to consolidate data from multiple worksheets into one worksheet.

Feb 19, 2009 | Microsoft Excel for PC

1 Answer

File in Excel is password protected

You'll have to download a program that will try and extract the password from the excel file. Passware is the best one I can think of, and can be found at ( It's a little pricey, but it's the best one i've found, and always gets it right the first time. I think the cost is about $125.00. I can't think of any free ones available.


Sep 17, 2008 | Microsoft Business & Productivity Software

1 Answer


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

1 Answer

MS EXCEL 2000 corrupted workbooks/worksheets

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Apr 29, 2008 | Microsoft Excel for PC

1 Answer

Excel Macro

Try these links you could find out

Sep 23, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

113 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides