Mac Forum / Applications / Excel / July 2006

I'm running an app I created in Excel 2003 for PC and am trying to
convert a version of the app for Mac Excel 2004. My main problem in Mac
Excel 2004: I have data validation lists that open half-off screen
(they do not in Excel 2003 (PC)). Aside from inserting new columns

I'm trying to create aprox 150 excel worksheets, the template and first
three pages work great except that everytime i copy the sheet i have to
manually change the formula links from sheet 1 to the previous page.
Numbers are inputed on a sheet and they need to reference totals from

I have an Excel (Office 2004) file with multiple sheets and no links that I can
find.
Whenever I open it and close it I am asked if I want to save changes even if I
have done nothing.  And sometimes recalculations never end and I have to force

I have an Excel spreadsheet (Office X, up to date) where I have 6
worksheets. On each sheet, column A are names, and the rest of the
columns either accept data or have formula.
I have linked sheet 2 A1 & sheet 3 A1 and sheet 4 A1 etc, to sheet 1 A1

I really need help in figuring out how to get a schedule to work for my
business.
I want to be able to daily enter the most current gas prices in a table then
in another area (or sheet) do some calculations using the last entry in the

I have created a custom toolbar for a project. I have attached it to the
worksheet, but when I open the file on another computer, it opens the
original version of the toolbar that I created. The modifications and
additions that I made to the toolbar after the original was created ...

i want to put my excel sheet in apache webpage and share with my team,
how can i do it.
Thanks for any help in advance
rajesh

Can you help?
I get a #VALUE! error with:
=IF(NOW()=DATEVALUE(E29),$B$27,"")
I want to enter the value of B27 if today's date is equal to the date in E29.

I have an Excel worksheet that I was given.  All the addresses are
mailto hyperlinks.  This is OK when the spreadsheet is complete and
correct, however, when it is being edited, it is a pain.  Is there a
way to select all the addresses and turn the hyperlinks off, and then,

In the vba coding im using, I eventually wind up with a 100x100 array.
Is there a way to output this to a surface graph (top down view) from
within VBA itself? or am I forced to display the data in a spreadsheet
in excel and then plot that?

I have a project that requires putting over 180 charts into a PowerPoint
presentation.  Is there a simple way to do this?  And/Or is there a way to
view the charts in Excel without clicking on each tab?
thanks!

Folks,
I've searched the web high and low, yet I'm not finding a solution for
my setup to the following issue (why can't people respond back to a
discussion group when they've found a fix?  I vow I'll respond when the

I've seen a few postings on how to set up macros to format comment
windows.
To avoid using the mouse and pull-down menu I've created my own simple
macro for inserting comments - this works fine in essence.

I have checkboxes in cells (technically over but not in the cell) that even
though protected and the sheet is protect, the user can still can
check/uncheck the checkbox.  How can I control which checkboxes can and
which cannot be accessed by the user?

Excel 11.2.3.   On some worksheets, with alternate color fill rows, how do I
override the fill color in particular cells or even whole rows when they
refuse to change when I highlight them and select a different fill color?
(I verified by checking under Tools that the workbook was ...