Mac Forum / Applications / Excel / February 2007

When working I will copy a cell the the view shifts from there back to
A1. How do i make the view stay focused on the area of the sheet i am
working on?

In my windows version of Excel there is an item titled "insert stock
quotes," which allows me to get various stock data items and return
them to the spreadsheet. I can't find this on the windows for Mac. Can
anyone advise me how to replicate this?

I often have problems getting formulas using Excel functions correct. In
part, the problem arises in trying to get a long formula in a single cell.
In typical programming languages, I would just break up the code into
several short lines that would be evaluated sequentially. In ...

Some time well over a year ago, through some weird accident that no
one has ever been able to explain, hyperlinks scattered themselves
across a very large spreadsheet.  There are two columns of email
addresses that are supposed to be hyperlinks, but now data in several

Does anyone know if a driver exists that will allow me to connect to
Excel via ODBC on a Mac?  I am looking for something that is
equivalent to the "Microsoft Excel Driver (*.xls)" driver found on
Windows machines.  This driver allows you to pull data from a

I don't know Excel at all - but I need to import an Excel 2003 Address File
into Outlook 2003, and I'm having a problem:  When I try to import it, I get
the Error Message that the Excel file doesn't have any "named ranges" - and
that I should go back into Excel to create a Named ...

Okay, I may be stupid but I have hunted and hunted to find where, in
the Mac version of Excel, one specifies or even finds the name of a
form object (in my case, a created combobox).
In the PC version, I can select Properties and voila. No such thing,

To the owner (or majordomo), of MICROSOFT.PUBLIC.MAC.OFFFICE.EXCEL
Did my first posting the other day.  Got helpful ideas from group.
Replied to each of two authors (and thought I cc'd myself); however,
no cc emails came to me.  And no replies from them has appeared.

I have a rather large data and formula spreadsheet and am trying to hide some
columns.  Some hide without a problem but others return and error of: Cannot
shift objects off sheet. Does anyone know what might be on the spreadsheet
that will not allow me to hide these columns?

Does anyone know how I can have a system whereby my entries on my
desktop (MAC) can be automatically linked and therefore updated in
another Excel file on a website?
I'd appreciate any help with this.

I have a table that contains 5 phases of a process, I'd like to have the list
of 5 phase available at the top of the spreadsheet and when you click on each
of the phases I would like the boxes that are relevant to that phase to
appear is this possible?

Does anyone know, how I could arrange data in cells from horizontal to
vertical? I do not need to change the direction of the text itself, I would
like to have the data from the 1st row in the 'A' column, second row in B,
etc.

Advice, please.  A workaround for this problem would be much
appreciated:
Am working on a Powerbook, OS 10.4.6.  As a start, made sure I updated
software for MAC and Office.

I've been trying to use the solver function in excel and ive been
scouring the internet for solutions but cannot find one yet.
I have office 2004 11.2.3 on a well equipped mac with os 10.3.9. I
checked the add-ins folder (Office 2004>Office>Add-Ins) and I have

A strategic partner who just switched to Vista sent us excel files
with a new weird ".xlsx" and my Mac can't open.
Thanks,
Weston@impactsf.net