Mac Forum / Applications / Excel / December 2007

When retrieving the 'value' of a range I get a list lists. When doing
a 'get XML value' of the same range I get a result but when asking for
the 'string value' I get an empty list. I think this is a bug. Can you
please confirm this and can somebody somewhere have a look at it?!

I am running Excel in a MacBook Pro. The Formula size is so long that
the right edge extends beyond what is viewable on my monitor. So the
grab tool on the lower right hand corner is not accessible, I don't
know how it got that way, but the bottom line is that I cannot resize

Hi, does anyone know how you can create a formula/macro for a template in
excel in that every time it opens it will give you a new number, ie, You
start with say 2990 for the first time and then for every time this sheet is
opened afterwards it will assign a new number and count ...

The following entry in Excel Help does not quite agree with my
experience: for me the word "EXT" is never visible.

We recently upgraded to Office 2007. When we attempt to do a trendline in
Excel, the order of polynomials is always one below what it is stated to be
and the highest ordered polynomial is always wrong. (i.e. on a fourth order
polynomial, it will only display polynomials through ...

Word has a keystroke shortcut for Project Gallery, but Excel does
not.  Is it possible to write an Excel macro that would open the
project gallery (and list Excel files only if that is possible) and
then either terminate macro at that point or wait until a file is

I deployed office service pack 3 to all 900+ machines at work and found out
that this security update renders all wk4 files blocked. I need to find a fix
for this due to my company using a AS400 system and Lotus notes. This file
type is needed to export data from the AS400 so it ...

Hi there.  I've just moved from Windows to Mac and wanted to find out how to
select non-adjacent cells on a worksheet.  In Windows you hold down CTRL and
click on the cells but this just pops up the shortcut menu in Mac.  Any help
would be appreciated.

I would like to customize my keyboard so that F2, as well as control
+U, will = "edit cell".  I can't find the "edit cell" command under
the customize keyboard dialog box.  What's the best way to do this?
I'm certainly willing to create a macro, but I also can't figure out

If have recently installed Office 2004 and had been using Office X for
several years.
I have a macro that dials the phone by calling a MacScript within the
VBA code. In Office X this works fine. By in 2004 it get an "Invalid

I'd like to save a worksheet as tab-delimited text with UNIX style
return characters (i.e. \n) instead of Mac style (i.e. \r).  Is there
any way to do this in Mac Office 2004?
Also I see options to save as both Text(Windows) and Text(MS-DOS).  What

This is hard to visualize, but basically I have a spreadsheet with a
couple of Columns.  Column A can contain duplicate part numbers and
Column B contains a person.
  A         B

I would like to copy dat from sheet2 to sheet1 as well as some data
form sheet3 to sheet1.  The data on sheet2 is a formula that reflects
the average of the 20 or so columns before it.  It is expressed as a
percentage.  I want to be able to work on sheet2, entering numbers,

I have recently switched from PC to MAC. I am opening all my excel
files in MAC now. However, when I try to print a worksheet - the data
in each column moves to the right - into the next column. Print
preview shows the worksheet correctly (as it is on screen). I have set

I've create a data entry field using the list wizard so I can utilize
pop-up menus. It appears to create the table correctly, showing be
column headers with the appropriate pop-up menu information. Catch is
every time I try to enter data - in any column - Excel crashes.  I'm