Is there a way to referance data from or to a closed workbook from an open
one?  I'm trying to referance data used in one workbook that is linked to
others and would like to have some of the data automaticly transfer the same
data into another workbook at the same time so as to ...

Maybe this isn't a job for Excel - if you know of a program that's
built for this, I'd appreciate the tip!
In XL2000, I'd like to make a table of items:
Col A = Description

I have just successfully added my new HP8500 wireless printer to my wireless
network and it seems to connect fine and print fine from some applications
except EXCEL 2007.  The spreadsheet prints fine in portrait mode, but the
margins are all off and I get partial printing if I ...

A simple question I think, how can I setup the Sort so it does not sort
the first 2 rows?

Como classificar em ordem crescente dados de várias linhas de uma lista

I have a set of Linux korn shell and perl scripts (don't worry if you don't
know what those are) that create a csv file that is automatically emailed
from a Linux server to end users. I want to apply some simple formatting to
the spreadsheet such as bold, column widths, number ...

We're saving an excel 2003 file (w/ no interactivity) to be hosted on a web
server.  It has 3500 rows, so obviously being able to always see the header
row would be great.
Is there a way this can be done?

The problem is as follows, I need to sort a range of cells that
contain values that have been calculated using functions and thus
don't contain "pure" text or numbers. Is there a way to have Excel
sort these sells according to the calculated value? I.e., the

I have some data in an Excel table which uses case sensitive codes. Does
anyone know of a way to perform case sensitive VLookups.
Example.
A1 contains "TEXT", A2 contains "One".

I'm currently working on an excel sheet for shipping. If my workbook is open
any other user can only access my sheet in read-only format. would it be
possible to allow all user access at the same time?

While working with excel sheets having rows more than 15000 lines, sometimes
I observe that the processing is slowed down if data more than 15000 lines is
selected. However the work is takes very less time if number of rows selected
are less than say 12000. I have 2GB RAM, Can ...

any way to use dynamic data in the sumifs function?  For example, the sumifs
function I am using is below:
=SUMIFS(Table5[Quantity Open],Table5[Item Number],A360,Table5[Release
Date],"<09/28/09")

I have some tables where there is a veriable in a cell next to searchable
text.  So if I search for the desired text and want to take the value of the
cell to the left of it what would that formula look like?

Hello , Can you teach me how to use 3-D shapes?
Thank You.

can you print data from excel so each row is formated to print on one page?
I want it printed on small cards.
is this possible?