Mac Forum / Applications / Excel / October 2007

The BesselJ function seems to calculate to less than full accuracy -
as little as 8 digits of accuracy vs. the expected 15 digits. I see
this both in Excel on my Mac and on a PC at work. This function should
produce 15 digit accuracy, as Matlab and Mathematica do.

When I use the auto-filter feature in Excel the down arrow for the drop down
box turns from black to blue. After working with this all day it gets hard to
tell the black from the blue, especially with a wide spreadsheet. I would
like to change the color of the selected column ...

I have a PC Excel file with a pivot table.  When I open the file in
MAC Excel there are no drop down lists on the pivot table reports.  Is
there a conversion trick?

Help! I'm trying to import a .dat file in Microsoft Excel for Mac
(2004). When I try to open the file itself from the desktop, I get an
error message saying no application found, and to visit microsoft.com/
mac. Can anyone help me? I've always been a mac person, and am not

I am trying to run an excel file that includes VB modules which was
created in a PC with Office Excel 2003 SP2 and VB editor 6.3 in a mac
with excel for mac 2004 and I get runtime errors.
Any ideas?

Excel will crash 9 times out of 10 when I try to print a workbook or
multiple sheets. Any suggestions?

I have recently moved from windows excel to mac.  When I have run my
macros written in visual basic on windows I can view the movement of
the cursor.  Now on the mac even though I have added the code
Application.Screenupdating=true the screen does not update during

I don't even expect an answer on this, but its been driving me crazy
for while. Why doesn't Excel for Mac support "Fill down" or "Fill
right" anymore? In older versions it was there as a "apple - D"
keystroke. Is there another shortcut I'm missing? Seems like it

I have entered the first, (really simple), line.  Upon dragging the fill
hndle, the row gets duplicated, & formulas do not step the cell-ID's. ?
What's my error?

How do I add PH Stat to my worksheet?

What do I have to add to the below code so that it changes all occurrances in
a text box as well as multiple text boxes?
Sub textbox()
   Dim FromStr As String

Hope you can help me here. I have a spreadsheet with 3 columns - date,
transaction, amount. The figures in the amount column contain positive
and negative numbers. I want to separate these into two columns so
that I can have credit and debit columns. Apart from moving each one

Newbie with Link woes....
How do I prevent Excel form replacing my relative link path with an
absolute link path that breaks ALL my List Links shared bewteen 2
workbooks and sheets?

I'm running Excel from Office 2004 for the Mac. Fairly frequently, the
formula bar gets "scrunched up" so I can't read the bottom line if I have
more than one line. I can fix this temporarily by selecting VIEW>FORMULA
BAR, to turn it off, then I turn it on again. But the problem ...

I have an excel spreadsheet that has eight cells that require data.
The calculations are based on the data being filled in a specific
order. (ie: (a) 1st, then (b) then (c) then (d) etc.).  How do I block
entry (gray out, lock, whatever) from all cells until the prior