Unable to perform excel operations

  • Thread starter Thread starter Neet
  • Start date Start date
N

Neet

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.
 
Maybe your "numbers" are really text.

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

Then try a simple sum.
 
Back
Top