Excel does not subtotal data exported from Report Builder 3.0 1

[AcctSolver]

This may not be the right forum; please feel free to repost to one more appropriate.

We have recently begun using Microsoft Report Builder 3.0. When we export reports to Excel and wish to further manipulate data, it is not working out well. We cannot do a data sort/data subtotal as we could if the data were originally entered into Excel. What steps must be taken to get the data to behave as though it were natively entered directly into Excel instead of being exported there.

 

[SkipVought]

hi,

Chances are the VALUES are STRING.

In an empty cell, enter a 1.

COPY this cell.

Select ALL the data in the imported table that should be numeric, including dates.

Edit > PasteSpecial - MULTIPLY

Your numeric data will now be actually numeric.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}