If you open Excel and in a new workbook, a new worksheet, select a
single cell (like D4) is cell formatting permitted? If so select a
range, format permitted?
Select a column, format permitted? Select a row, format permitted?
You need to see if the problem relates solely to the ex-Access data, if
so you can save-as to a .csv file, open that file in Notepad to check,
save as a new .csv file, and then import that into a clean workbook.
That should remove any problems (should).
However, life being what it is, do you have any macros loaded? Tools,
Macro, Macros, if there are macros there are they yours and correct?
Do any other old worksheets have this problem?
Any other clues?
If the problem persists, can you save a copy of the book, then delete
all but a few rows, overtype data to disguise it, then post a copy ?
Stefi Wrote:
Hi Bryan,
This method didn't help, on the contrary it gave an entirely
surprising
result: Cell formatting dialog doesn't come up even if entire column or
row
is selected. I tried to copy the content into a separate workbook, the
result
is the same. (XP, Excel2000).
Stefi
€˛Bryan Hessey€¯ ezt Ć*rta:
Not heard of this before, but if it's a single sheet you could
Insert,
Worksheet, copy the old worksheet, select cell A1 on the new
worksheet
and Paste Special, Values (assuming there was no intended formatting
transferred)
Stefi Wrote:
Hi All,
I have a workbook exported by Access. Selecting a unique cell or a
range of
cells the cell formatting doesn't work neither chosen from the
menu
nor
right-clicking on the cell (the formatting dialog-box doesn't come
up
at
all). Selecting an entire column or row cell formatting works
normally.
What is the cause of this and how to fix the problem?
Regards,
Stefi
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=392850
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=392850