Mac Forum / Applications / Excel / January 2005

I transferred some of my organization¹s Excel templates from PC to my Mac,
but in the Finder they don¹t show up as ³Microsoft Excel Templates², like
the built-in ones do. I downloaded a template from the Mactopia site, which
also has the .XLT extension, and the Finder still doesn¹t ...

I'm using Solver in Excel 2004 for Mac.  In the Solver Parameters dialog box,
clicking Reset All results (every time) in the following error message:
"Solver: An unexpected internal error occurred, or available memory was
exhausted." Then, Solver quits and returns me to my ...

A cell with ariel font, text wrapped, shows correctly in "view Page
Layout", and in "Print Preview", but does not print correctly in any
printer we have. The text to the left of the cell is hidden. Any ideas
much appreciated.

I have developped an accounting application (freely available) on the MS
Windows Office 2000 version of Excel. This version has been installed on
various machines, including Windows XP and Excel running on Macintosh.
Recently one person attempted to move his workbooks from an old ...

I know this is a basic question. I¹m using Excel as a DB to keep record of
my expenses for taxes. I assign a name to each account in an Œaccount¹
column. I¹ve been told there¹s a way to have Excel sort by account and give
a total for all the entries that have that account code.

I'd like to name a database range, and use that name in formulae and
pivot table reports. Is there some way to make the range that the name
refers to expand automatically when new data are added? I've tried
using a list name (from the list manager), but worksheet formulae

I have an Excel workbook that I created in 1998 - I have used it
continuously in the 7 years since then.  Today for the first time ever
I received this pop-up window:
"The workbook you are opening contains macros.

I'm hoping someone has an idea on how to accomplish what I'm trying to do:
I have an excel workbook with multiple sheets.  One sheet includes input
fields for a series of topics, the next contains a series of calculations
driven by the input values on the previous sheet.  The third ...

Hi, I have an Excel document that prints perfectly in Office X.  However in
Office 2004 the page looks like it is shrunk by 25%.
I have both Office X & 2004 installed on the same machine.  If I print from
2004 its shrunk, is I switch back to X its fine.

No, it does not work that way. I tried modifying the settings in
multiple ways but Excel works the same (commas instead of points and
viceversa).
Any other idea?

Via VBA, I have created a custom toolbar that has a quite a few regular
buttons, plus a popup button that contains several choices.  Each choice
runs a different macro.  I'd like to make the user's last choice from
the popup button "stick" for reuse.  For example, when using the ...

If I have a data set and fit it with a polynomial, how do I put the
coefficients from the fit into a worksheet so that I can do some
calculations using the fit parameters without manually typing them in.
I know you can easily do this if it is a linear fit by using the LINEST

Whenever I try to print a multi-page excel document on my HP PSC950
Printer only one sheet prints at a time.  I can go in and select
individual sheets to print, but that requires printing one page at a
time.  I have downloaded and installed the latest printer drivers

Running excelX, Panther 10.3.7
Is there a way to have a separate Personal macro workbook For each user.
Other users running macros have access to my Personal Macros which I use
In different workbooks.

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?