Hi, the problem I have is this.
Let's say you have three columns.
Country, Currency, Company.
If I fill in the country column "Japan", is there a way to have i

Hey there I just spent a few hours trying to come up with a solution t
a problem I am having.  The problem is this.   I have two exce
spreadsheets that need to be merged.  The issue is that one of th
sheets has more info then the last.  An example is this

When I try to import data from two access database tables
using query I get a message "type mismatch in expression"
does anybody know what this means and how to rectify it?

When I open a certain text file either with the macro listed below, o
from windows explorer, Excel inserts a blank row between each row o
data.  Is there some setting that can be changed to correct this?
Any assistance would be appreciated.

I have a sheet that is protected. I would like to unprotect it, hide some
rows, and re-protect it under macro control. I realize this may expose the
password, but, let's face it, security is tentative at best.  
Thanks../Randy

I used to be able to insert dates this way in other versions of excel but it
does not work anymore!
Why ?
Thanks!

I am looking for KB291070,  KB214032, KB113600. I can find KB291070 in
Japanese, but the 2 others are gone. I can find plenty documents which links
to them and a month ago KB291070 was also there.
All KB's concerns Excels inability to save to drives where you don't have

Is there a simple function to return the sheet/tab name of a worksheet... In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I don't

Is there a way to hide columns so that no one else can unhide them ?  Need
to send a file with data in 2 hidden columns that I don't want to be
unhidden and I don't want to have to delete them.
Thanks !

i've a database in excel. I need to print a specific Report in MS-Access
using a particular record in ms-excel.
OR
I've 2 worksheets.

XL2K: How do I delete an add-in (*.xla file) from the Tools drop-down menu
if it is already been removed from the "Add-in's available" list and from
its default location?.
TIA

I was asked to help out with a clerical error that lost an excel
spreadsheet.  What happened was, she accidentally performed a "save as"
after deleting a lot of data in preparation for a new version of the sheet.
So now it's either find it somehow, or re-enter the data.

hi all..i'm a new user off Microsoft Excel,i have a
question abt Excel here.what format did Microsofe Excel
using for the colum measurement?"cm"?"mm"?"point"?or else?
can the format be change? if can,how to change it?

Hi I have a cell that I want to know when something will be finished i.e.
today()+30.which gives 02/07/04. This is ok until I open the spreadsheet
tomorrow when I will get 03/07/04. How can I get the date 02/07/04 to remain
every day or do I just enter the date manually?

Can anyone help with my problem what i want to do is add up the tota
for a given criteria in a column when it meets conditions of two o
more other columns
--