Unable to perform excel operations

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.
 
D

Dave Peterson

Maybe your "numbers" are really text.

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

Then try a simple sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting excel to PDF, single page converts to multiple HELP! 1
How to record a macro within a macro 9
Radical color chages on importing a worksheet (Excel 2010)? 0
Please Help!! How do I export a Cashflow from MS Project to Excel? 0
How to embedd an excel table in access to generate pivot report 0
Script to refresh data and save and close 3
using the Excel generic worksheet names instead of user-given names in code 5
Time Sum in Excel 1

Top