Mac Forum / Applications / Excel / April 2007

I'm using Excel to create a workflow chart for myself. I have six
columns signifying various events in the progress of a project. I'd
like to be able to just enter the start date in the first column, and
have Excel fill in the other 5 columns for me.

Using MS Office (Student Version) 2004 on an Imac Intel Duo Version
10.4.9
I'm a novice and need a bit of assistance.
I've set up Table_One containing $ and ç using cells C1:E10

So, VBA isn't supported in Office 2008.  And the only built-in cross
platform scripting option seems to be something called XLM.
Does anybody know where I can get editor for this?  Do I have to buy
it?  If so, from whom?

I have been leaning to use array formulas. As an example, i have a simple
2-column situation with data in cells a1,2,a3,a4,b1,b2,b3,b4 as follows:
a1=apple, a2=apple, a3=orange,a4=orange,b1=red,b2=green,b3=red,b4=green.
(So there are 2 apples and 2 oranges of which one of each is ...

I have been getting the  "AutoRecover has been disabled for this
session of Excel" error message more and more frequently.  My specs:
1)  MacBook Pro, 2 GB RAM, 2.16 Intel Core Duo
2)  OS X 10.4.9, Excel 2004 (latest updates applied)

Can anyone tell me if it's possible to put workbook sheet names in
cells in another worksheet, and use those for reference purposes?
Suppose, for example,  I have worksheets named A, B, C and D. I put
those names in cells in worksheet E. Can I then, say, do a VLOOKUP or

I've recently moved over to MAC. Been using a macro that open a text
file. However, in Excel 2004 for MAC an error appears:
Run Time Error 1004
Method 'GetOpenFileName' of object '_Application' failed

I've researched this for the past several days, but I've been unable
to find reports of this in the past.
I work in an animation company, and we're in the middle of production
of a couple new shows.  We've never had any problems in this area in

I am currently working on my Excel docs on a computer that doesn’t have a
printer attached while my computer is in the ‘shop’ for repairs, and am
unable to edit/view my headers or change my page setup. I get a message that
I don’t have a printer and can’t get any further. Does ...

Forgive me if this is easy but I'm not an Excel power user.  I am
looking for a way to have a hyperlink automatically created based on the
input of a cell.  Basically I have a column with data sheet numbers.  I
would like a hyperlink to be automatically created each time I enter ...

I just installed Office 2003 and I want to change the color of the icon that
I am pointing to.  In addition the color of the cell locator A, 1 for example
is the same obnoxious orange color.  Where do go to to change these colors
without changing the XP color scheme (XP style, ...

I want to set chart preferences to interpolate a line between data
points flanking a zero value, but I don't want to have to delete the
zero from the table (leaving a blank cell) to make this happen.  Is
there a trick?

I am trying (Excel 2003 Window XP home) to create a number of graphs (±200)
using a macro. The sequence I use is as follows:
Select cell at top left of data range
Go to "tools" "macros" "create new macro"

The adobe photoshop (CS2) is not showing up in my dictionary choices.  I have
reloaded office in the same application folder as CS2...
Any ideas?  Should I reload Photoshop?

Please advise on the functions to schedule a fully amortizing loan
outputting periodic (and cumulative) interest and principal payments.
Do I use cumipmt or cumprinc or another function?
Thanks.