I often receive Lotus 123 files and have opened them with Excel without
problem.  I just downloaded Service pack 3 for XP and now am unable to open
them with Excel.  I receive a message "you are trying open a file blocked by
your registry policy setting"  What do i do??

Is there a way to have the zero appear with a slash thru it?
I hav checked the symbol library and have had no luck.
Thanks

I have 5 sheets of products and I want to create random item numbers (6
digits). This is a basic inventory list.

I have three columns of text (4 digits each).  I need a logical test that
show true if all three equal or false if any of the three are not equal to
the others.
I've played with If statements, but cant get it to resolve.

Is there any way to hide and lock cells on a worksheet without affecting a
Macro? I have written a Macro that hides rows on a worksheet that have zero
value, I run the Macro through a form button. However, when I protect the
worksheet so the hide/lock feature takes effect, it ...

How do I export a row of data which includes a large amount of text in most
cells into a single page report.
Ideally I would like to be able to select the row number and simply print
the report using the data from that row

The size of characters in the display of worksheets Sheet 1, Sheet2, Sheet 3
is too small.
How can I change the size of these characters?
Thank you in advance,

I often select cells and use the fill handle to populate data in my
worksheets, but it's a royal pain using my mouse to drag the fill box all the
way down a spreadsheet containing thousands of rows. Is there a keyboard
shortcut to dragging the fill handle to the top/bottom of the ...

aHi, could anyone tell me how to select numbers from a list/column that
differ from other numbers on the list by e.g. <1? Can I do this by inserting
formula or would this involve programming? Any help would be extremely
appreciated.

I would like to make a button that would save only active sheet and get
name from cell "C5".
i.e. save active sheet "Invoice" only and name from cell "C5" which invoice
number "55"

I upgraded excel 2003 to 2007 and have large multiple worksheets and links to
other excel worksheets.  I get errors saying not enough system resources to
display completely the screen freezes and I must shut down.  Please help this
problem only started since the upgrade- What ...

In all my w/sheets of my active w/book ,range("M5') has a value "pending" or
"completed". I need a function that returns list of those work sheet names
with"pending" value in range("M5").
Thank you all excel experts in advance.

In some worksheets, a cell formatted hh:mm with a value of 24 will yield the
desired result - 24:00 (24 hours).  As of today some worksheets are yielding
00:00 for the same value of 24, and in the formula bar, you can see that the
24 has been converted to 1/24/1900  12:00:00AM - ...

I have s spreadsheet where the data are in ranges,
with some cells empty,
and I need to sort the data by a velue in one of the columns,
but to keep the ranges as they are.

I have downloaded an 2003 excel spreadsheet.  WHen I view this file in 2007  
I do not have any scrollbars.    I have looked at excell options /advanced
and scrollbars should be available but they are not.
I can not enter new cells that would fall below the max size of a window.  I ...