Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Cell Format Not Available - Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jpidgen@rogers.com - 23 Jan 2006 21:55 GMT
We have an old spreadsheet that was originally created by Excel 2000.
It is a complex workbook with many formulas.  It does not have locked
cells, nor is it protected.

The problem, is that a bunch of cells will not allow for formatting.
We can't figure out why.  If one right clicks while on the cell, the
short-cut menu appears, but if you click on "Format Cells" nothing
happens (it doesn't take you to the next menu).  The same happens if
you go through the toolbar and try to click FORMAT then CELLS.

I've searched a couple of databases and I can't find any reference to
this type of problem.  I'm hoping someone here might be able to help.

Thanks!
millsy - 23 Jan 2006 22:08 GMT
Are you sure that the creator of the worksheet did not protect the
formats?  Try Tools>Protection>Protect Sheet and see if any of the
format protecting options are ticked.

Signature

millsy

jpidgen - 23 Jan 2006 22:19 GMT
We're triple sure that the worksheet is not protected.  That's why this
is so frustrating.  The strange thing, is that not ALL the cells in
this worksheet act this way.  There are areas that will allow
formatting and other areas that will not.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.