Mac Forum / Applications / Excel / May 2007

I trying to do a find and replace, but replace is grayed out. I've tried
altering every drop down in box, but stays grayed out. Any idea? Thanks
Also (to just delete, you would just leave replace box empty, correct?)
Kevs

While I realise that MicroSoft is an American company, not all of us want
american the format for our spreadsheets!!!
I have my machine set for UK formats - which is fine for general computing,
but in Excel the date format keeps displaying MM/DD/YY format.  

I'm trying to find the AppleScript equivalent of saving a sheet as tab-
delimited text, but I'm either misunderstanding the available "as"
constants, or have run into a bug. I'm using Excel 11.3.3 under OS
10.4.9 on an Intel-based Mac.

Is there a way to configure an Excel Workbook so that it displays in
the dashboard?
Thanks.

I don't have Solver in my tools menu and when I try to install it
usingthe Add in feature its not there.  Can anyonetell me what I need
to do.
thanks

Now that M$ is mulling over a conversion from VBA to Applescript ...
Is there a way to call Applescript from VBA?
That would allow developers to make controls (such as dropdowns and
buttons) whose triggers evoke Applescript instead of VBA.

I maintain several small Excel databases on my non-Intel Mac Mini (OSX
1.4.9). I also use AppleWorks 6 to convert them to the AppleWorks format so
they are readable by other Mac users who don't have access to Excel.
After conversion from Excel to AppleWorks, I find that many of the ...

Hi...
I am having trouble hiding a single column when this column includes a
merged couple of cells in a row.
Basicially, I am running an expense report where one column is the

In trying to open a spreadsheet that was e-mailed to me, I get the
message "Name conflicts with existing module, project, or object
library". And I click OK and I'm back to square one. Any suggestions?
I have an old version of Excel -- Microsoft Excel X for Mac.

Is there a way for excel to tell me the character count for all the cells in
a certain column? Thanks!
Kevs
OS 10.4.7

My version of Excel 97 will solve =exp((5/8)^2) but it will NOT solve
=exp((5/8)^2.2).  Whenever I put any decimal fraction for an exponent in
=exp( ) it will not solve it.  I get #NUM!.  My TI83+ will solve it.
Thanks

I need help please. When I am sent Excel files via email or CD and try
to open them, I get an error accessing system ristry message, I can
still read and use other Excel files?
Thanks<

That little clipboard that automates this when you copy paste, how do you
temporarily turn it off?
I can't paste properly because when I do the drag, it jumps to cells way
further down that I want to go!

Using Excel 2000
I'm trying to consolidate my workbooks.
When I click Data, Consolidate, type
the References, Add, OK, I get a message

I currently have a excel spreadsheet that is a fairly complex
application that works perfectly in Office 2003 and 2007. I am trying
to make it compatible with Office 2004 for Mac. However, I require 2
libraries: