|
|
|
|
Hi Bryan,
I was on a holiday, that's why I reply only now.
If you open Excel and in a new workbook, a new worksheet, select a
single cell (like D4) is cell formatting permitted? YES
If so select a
range, format permitted? YES
Select a column, format permitted? YES
Select a row, format permitted? YES
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). IT DID!!!
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? NO
Do any other old worksheets have this problem? NO
Any other clues? NO
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 ?
The problem is now solved via a bypass. What's your opinion, does it make
any sense to search for a direct solution (or at least explanation) any
longer?
Many thanks,
Stefi
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
|