i'm trying to ctl-drag to copy a worksheet to a different workbook. however,a
window pops up with "Too many different call formats" error msg. can someone
please explain the cause? I can't even seem to copy the format into the
copied worksheet.

Thanx

Well, it means exactly what it says - you have too many different
formats when you drag that sheet into the other workbook, as there is
a limit to the nuber that Excel can cope with.. You will have to
simplify the formatting in one or more of the sheets.

Hope this helps.

Pete

On Nov 7, 6:14*pm, Stan wrote:
i'm trying to ctl-drag to copy a worksheet to a different workbook. however,a
window pops up with "Too many different call formats" error msg. can someone
please explain the cause? I can't even seem to copy the format into the
copied worksheet.

Thanx