Mac Forum / Applications / Excel / December 2005

Sorry for my very bad english but I am italian...
I have a problem with Excel 2004, latest patch. I have created a sheet,
selected data into sheet, and I have transformed this data into list with
command "Create list"

I am trying to send a spreadsheet that uses analysis toolpak functions
(e.g., edate, xirr) from a mac user to a Windows user.  I have never
had a problem before if the recipient had the add-in enabled, but for
some reason I am having problems.

How does one get the text of an Excel 2004 comment in Applescript?
I've tried such things as "get value of Excel comment", "get text of
Excel comment", etc, with no luck.  Here's an example based on the
sample on page 83 of the Excel 2004 AppleScript reference.

XL 2004 Drop down box font size appears to be same as font used in the sheet
When the same workbook is opened in XL 2002, the 12pt Arial in the sheet
appears to be about 8pt in the drop down box
Anyway of controlling Drop down box font size?

I received the error "No more new fonts may be applied in this
workbook." while trying to copy a chart. Google pointed me to this
Microsoft knowledgebase article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;215573&Product

Can anyone tell me if there are known bugs with sharing a workbook?  I have
2 users sharing a 2001 workbook, and we seem to have issues with the changes
not being saved.
Please help!

Why is it that I can't seem to set Excel's prefs to NOT display page
breaks globally? Whenever i open a new document, I have to go back and
reset that preference, which defaults to displaying page breaks every
time. It's driving me crazy!

Gang,
I'm using Excel v11.2 under Mac OS 10.4.3.
I have a relatively large spreadsheet in List Manager, using visuals
and the totals row.  It is currently 888 rows (including the * and

Using Excel X for Mac, I'd like to find all commas in a column and
replace them with hard returns/carriage returns (not soft returns).
Since Excel doesn't recognize the Cntrl-Option-Return combo when I use
the Replace function, I'm guessing I'll have to use a formula or a

I'm looking for help counting multiple pieces of data shown together
in one cell separately. Ex: A cell has "M, R" in it. How do I tally
the M's and the R's separately in my totals? Thanks!

Okay folks... I'm an idiot.  Here goes:  is there a way to "automate" excel
in order to pull figures from one spreadsheet and place them onto another
spreadsheet.  For instance, let's say I have worksheet entitled "list" with
30 items listed in in column A - the item "banana" is ...

SInce downloading the latest update for Office X I cannot get either
exisitng macros in my spreadsheets to work. I have tried recording a
new macro which seems to go ok but when i try and run it the same
probllem occurs. Any suggestions

The latest update to Tiger to 10.4.3 build 8F46 appears to have broken my
SpreadSheets ability to perform a web query using VBA. I've tried using older
versions of my SS which I know work plus examples that do simple stock quotes
and they all report 1004 errors, Query failed. The ...

I prefer to list my two new things Œproblems¹ but they are nevertheless a
nuisance and appeared only recently.  Unfortunately I have no clue how and
why they show up and would appreciate any hint where to look:
1. When I open Excel it starts with a message that says in a small Excel

I am trying to make a new name range in Exce 2004 but it fails.
I have tried many different ways but am getting to the conclusion that
it just may not work.  Does anyone have some insight into this?  Thanks
Here are a few example of what I've tried: