Unable to perform excel operations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neet - 03 Feb 2004 09:02 GMT

I have a VB application through which I generate a crystal
report(version 8.5).When I export the report file in excel
sheet format I am not able to do any excel operation on
that sheet such as pivot table sum etc. I have also tried
to copy the data in the excel sheet and pasting it in a
new excel sheet but still the problem is persisting. I am
using MS Office 2000. Can anybody help me out.

Reply to this Message

Dave Peterson - 04 Feb 2004 00:25 GMT

Maybe your "numbers" are really text.

Try copying an empty cell
then select your range
edit|paste special|Add

Then try a simple sum.

> I have a VB application through which I generate a crystal
> report(version 8.5).When I export the report file in excel
[quoted text clipped - 3 lines]
> new excel sheet but still the problem is persisting. I am
> using MS Office 2000. Can anybody help me out.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message