Mac Forum / Applications / Excel / May 2007

I have 5 workbooks, each with at
least 3 worksheets.
In the end, I want 1 workbook
and 1 sheet.

I have a spreadsheet that is using lookup tables to auto-fill data
when you enter a part number.  Until the part number is entered, the
lookup cells show N/A.  Only problem is, I have Total cells at the
base of each column for costs and such, and it won't show a total with

I've already created pull-down menus from a given list of product, so
that the user doesn't have to input a part number manually each time,
but I want to add more detail to the data list.  I'd like to add
categories to contain the part numbers.  Is there any way to create

Trying to wrap column to column on one page can this be done? My
question is if I complete one column on (1) page can I automatically
continue to another column on that same page?

I copy spreadsheets from Excel (Office MAC 2004) and Paste Special
(picture) into Word documents. If I am copying a somewhat large number
of cells, part of the pasted picture is not visible, but the corner
markers are there (hope that makes sense). Is there a setting I can

I have a spreadsheet with many rows that were manually set to a
variety of row heights.  When text is changed, the fit of the row
height to the amount of text present in a cell is frequently not
good.  The Format-Row-Autofit command ignores rows with manually set

I used to have a dialogue box at the top of the excel spreadsheet
which allowed me to edit cell entries-I seem to have lost that box and
wonder if someone can tell me how to get it back??
Thanks,

When trying to open Excel the following problem occurs  the windows installer
window flashes on then another box opens and reads "an error occured and this
feature is no longer functioning properly would you lke to repair this
feature now yes or no" on clicking yes the installer ...

I have 500 contacts listed in electronic text
format. How do I transfer them to an Excel
spreadsheet. Is there an easy, error free
way to do this besides copy and paste?

I'm writing a macro that needs to run on a PC and Mac.
I have the code working on both platforms, but the Mac is incredibly
slower.  What takes 20 seconds on a PC takes over 12 minutes on the
Mac!  Another thing that takes 1 second on the PC, takes over 2

I'm writing a macro that needs to work on PC and Mac platforms.  I'm
using PC Excel 2003 and Mac Excel 2004.
I'm having a hard time getting a consistent format/look between the
platforms:

I'm doing VBA in Excel 2004 on a form.  This code gives me a 424
undefined object.  I guess that means it wants me to define the
textbox control?
Private Sub CommandButton1_Click()

I have a spreadsheet with 20ish charts that I would like to include in
a Word document. I would like to be able to change the Excel data and
the graphs update automatically in the Word document. I have been
trying to use the paste special and link option.

Why can't I use CInt on  this line?  I get a syntax error.  Is there
no CInt function in Excel 2004?
I want the user to pick  a string value in an  array and then have the
value converted to an Int.

Is there a date or time Picker control in Excel 2004?  Or do you have to use
the list wizard.  I'm following the Georgetown Cleaning Services tutorial.  
Otherwise it looks like I ahve to create a comboBox but how do I attach a
date calendar so the user can pick any date.