I need to transfer one mainframe file to PC in excel format.
This needs to be done  automatically like FTP with out manual
intervension.
We create report every day in mainframe file format and this report

I have a massive file which contains many sheets and i have one summary
sheet with a column of hyperlinks which reference each sheet separately.
Since i continually strive to not use my mouse, i bugs me to have to grab
the mouse solely to activate a sheet.  all of my work is done in ...

I'm working on an Access 2000 database where I will have a spreadsheet on a
network drive.  i need people from other groups to update the spreadsheet,
but i need that info carried into the database and then back onto the
spreadsheet.  i have the access -> excel part figured out ...

I have Windows XP and Excel 2002 SP3, I have go into Edit>Links>Startup
Prompt and selected the radio button for Don't display the alert and update
links.  However everytime I open this workbook I am still asked if I want to
Update.

I have a spreadsheet that someone spent a lot of time on, in getting data
presented exactly how they wanted it. A report I have from Crystal will
export the same information to a spreadsheet, but guess what: not as
presentable as the historical spreadsheet.

I'm using windows xp and am trying to link 2 worksheets using the following
example:
Sheet 1, block 1A equals Sheet 2 , Block 1A using this command =Sheet1!A1
My problem is that as soon as I type this in a press enter, if the source

I have created a worksheet in Excel 03.  I am trying to link a large number
of the cells to another worksheet in the same workbook.  When I use Paste
Link to link 1 cell only I get an absolute reference ($).  When I try to link
numerous cells at once - I get the exclamation mark ...

I have an access database.  In this database, I have several forms and
reports that need to be sent via email to other individuals.  They need to
enter info into several locations and then return via email to me.
If I export the form/report to excel, the format is lost.  Is it ...

I am new to this so bear with me, please.
My first sheet of the workbook is my master which contains 9 columns -- 2
columns have a formula to calculate % of increase between "old" and "new"
price.

I have developed several Pivot Tables, in Excel, which use a live link to an
Access Query.  I am updating these queries to make them more comprehensive,
across multiple time periods and have made them into Union queries.
When linking these into a Excel Pivot Table, I receive an ...

Please, someone have a macro for sorting hyperlinks?
When I sort a selected area with hyperlinks the resulting hyperlinks are
disabled or mixed-up.
I can send an example of the file.

I have added button inside excel sheet(not vb control). Is it possible to
add tooltip text for this?
I am able to set tooltip text for vb controls. But i cannot use these
controls inside excel sheet.

Another employee and myself find that our bosses are giving us more and
more work that revolve around the same information that we enter into
several forms, such as names, customer number, dates of action, dates
needing to be complete by, rep. handling the file, and so on. We have

If I have in a cell reference
=SUM(A3:A300)
how to have 3 and 300 referenced to another cell so that I can change range
without changing formula?

How can I find the cells that have an external link to another workbook.
Thank you.
Branko