I have three workbooks that I'd like to consolidate into one workbook
with 3 sheets. Workbook #1 contains linked cell references in
workbooks #2 and #3. How can I move the worksheets from workbooks #2
and #3 into workbook #1 while maintaining the integrity of the linked

When I click on File, among other things that show up,
are the last four files that I have opened.  Is there a way
to change the number of files that show? e.g. could I have the
last six file  names  accessed show  up?

Morning,
I recieve a fuel report daily that list all the equipment that's fueled, the
gallons, odometer reading and unit numbers. I copy and paste this report into
an excel spreadsheet. I have a spreadsheet for each month. It's fairly easy

I need to design a form used for registering swimmers for a team that can
import data from Excel or Access.  Can a Word form be used?

I have an "array formula" that uses multiple criteria to do mimic a "SUMIF"
with more than one possible criteria.  
Essentially it is {SUM(IF((C3:C15<>"X")*(C3:C15<>"Y"),1,0)*(D3:D15))}
I want to change the sum range (that is, the (D3:D15)) dependent on some

I have run into an issue that when the text in the cell is greater than a
certain number of characters, it is displayed as "#####################". If
I change the cell type to "General" instead of "Text" then it displays fine.
How can I fix this so that the type can be "Text" ...

I have an Excel file (using 2003) that has a row of entries for
actual expenditures for each month (months in columns).  I want to
calculate the cumulative expenditures, plot them when actual
expenditures are entered, and not plot them when actual expenditures

Good morning
I receive the following message everytime I start the application:
FUNCRES.XLA is already open. Reopening will cause any changes you made to be
discarded. Do you want to reopen FUNCRES.XLA?

I have a problem with "Freeze Panes."  I have a shared Excel file,
where the top row is frozen.  Every once in a while, the entire page
becomes frozen.  Everyone that uses this Excel file has denied
unfreezing and refreezing the panes.  Does anyone know how this could

Hello, I'm trying to map XML elements to a workbook.  
Each column in the workbook has hundreds of rows,  so the .XML map file is
formatted in a such a way that excel detects an XML list is being made.  When
I drag the XML elements onto the workbook - to complete the mapping ...

In 2003 Excel, you can copy your chart to another sheet within a workbook
and edit the data. The new graph will reflect the new data of the new sheet.
In 2007 Excel, when you copy the chart, it will still reference to the
original data_ you'll have a graph that doesn't match your ...

I would like to chart some various housing compounds based on rental
rate (y) vs their size, in this case bedrooms (x). I can get the look
and results that I want, but I can't get the label of the compound
(A,B or C) next to the data point.

Is it possible to have data that is typed in a worksheet to be added to
another worksheet of the same workbook.
I have my inventory worksheet with pricing and other info needed. I also
have another worksheet in the same workbook but all I need is the pricing

I have been trying to find a way to save a .xls workbook to a .pdf file.
Does anyone know if this is possible through vba / macro.
I know there are a number of products out there, but was trying to avoid the
purchase and code around it if possible.

Question: I maintain an issues list in Excel. One column contains notes. I'd
like to somehow enter today's date (or today's date and time) into a cell
with existing text.
The eventual output would look like this (all in one cell)