Mac Forum / Applications / Excel / June 2006

For those about to troubleshoot, we salute you!
We are in the process of migrating Mac users to SMB shares and we've
run into a hitch with Excel for the Mac.
Server: Windows 2003 SP1 - yes permissions are o.k. <g>

How do I draw and Box and Whiskers chart using Excel?
Thanks,
EV

I have been using Excel on the Mac for 20 years, but there's something
elementary which I'm missing about window activity.
When I open most of my workbooks, Excel has memorized the last window size,
window position, degree of magnification, toolbars to be displayed, etc., so

I am trying to figure out how to create a macro that will look into a
specific directory on the hard drive filled with identical excel files,
pull information from the same specific cell on the same workbook in
each file, and then write it to the active workbook as a continuous

I'm a dedicated Mac and Excel and VBA user.
Right now my current Mac (1-GHz PowerPC) is about 10x slower than the
comparable windows machine for executing VBA macros in Excel.
My question is: Do the new Intel-chip Macs do VBA any faster than the

I want to display the date that I last saved the spreadsheet.  Is this
possible and how do I do this?  I have Excel 2002.
Thanks!

Count coloured cells
Some months ago Bernard Ray gave me the functions repeated below and these
were used to good effect to sum the values in differently coloured cells
using the following:

Dear Experts,
I am so stuck, please help...
I am using OSX Excel and I am trying to export cells to a text file by
a simple Macro.  Unfortunately, some cell values are Japanese and the

I've been using the MS saved web query to lookup currency rates. It
seems to have changed recently and the Euro is no longer listed.
Anyone else have the same experience?
Is there somewhere else I can get a web query to lookup the euro?

I'm a novice to XL (2004 Mac)  and I am trying to create a form that
would do something rather complicated.  It's hard to explain, but it
would be used to break down scenes in a movie.  Every 8-1/2 x 11 page
would have five of these forms.  Each form would have about 10 fields

To All,
I've seen many ways to extract formatting data from cells, but I haven't
been able to figure a way to set the color based on cell values other than
Conditional Formatting.  Conditional formatting only allows for three

I want to record a macro. I start recording, marking the cells,
choosing format > cells, use 1000 separator, decimal places: 0, stop
recording.
When I run the macro, the numbers have only one desimal and no

Yesterday, I was working on my fiscal year end (FYE). My books are kept
in Excel. In various extract sheets, I have to change links from the
last FYE GL to the new FYE GL. I made a VBA macro which used the
Workbook method 'changelinks'.

When I use find/replace, I can barely see the "found" cell because it's
outlined in a very pale peach color.  I need to change the color to something
I can actually see, but I can't figure where to do that.  Can anyone help
please?

I'm looking for a macro that will find the largest number in a column of
numbers and automatically + 1 and insert that number in the cell of the
column anytime new row is inserted or row of data is added to the column.
Anyone ever seen anything like that?