I'm exporting data from a form library view in WSS to excel using the
SharePoint capabilities and this works fine, but later I'm trying to program
a Macro that give format and calculate statistics for the library figures
using the excel functions, but apparently the exported Sharepoint list have
access limitations becuase the formulas simple doen't work, and are easy
formulas like SUM(list84063!D2:D6) or AVERAGE(list84063!E2:E6), I simple
reveive bad results as empty spaces or 0 eve when the list have values.

Have anybody an idea about what could be happednand how to get full access
to the exported figures?

I test inserting manully the formulas after the list and works fine, but if
I use a macro to automate the process on the same Sheet or another sheet the
results fails as described.

I will apprecite any help

this type of problem is generally because the data, although it appears as
numeric, is stored as text. You can try using a formula like

=SUMProduct(--(list84063!D2:D6))

or
=SUMProduct(list84063!D2:D6*1)

for average, you would need to do
=Average(list84063!D2:D6*1)
and enter the formula with Ctrl+shift+enter rather than just enter since
this is an array formula.

An alternative would be to clean up you data.

On way to convert it to numbers is to format the columns as General.

then put 0 in a blank cell, copy it to the clipboard, then select the data
and do Edit=Paste Special and select Values and ADD.

another is to select the column and do Data=Text to Columns, select
delimited and space as the delimiter. This should cause them to be
reevaluated as numbers.

--
Regards,
Tom Ogilvy


"Daniel" wrote:

I'm exporting data from a form library view in WSS to excel using the
SharePoint capabilities and this works fine, but later I'm trying to program
a Macro that give format and calculate statistics for the library figures
using the excel functions, but apparently the exported Sharepoint list have
access limitations becuase the formulas simple doen't work, and are easy
formulas like SUM(list84063!D2:D6) or AVERAGE(list84063!E2:E6), I simple
reveive bad results as empty spaces or 0 eve when the list have values.

Have anybody an idea about what could be happednand how to get full access
to the exported figures?

I test inserting manully the formulas after the list and works fine, but if
I use a macro to automate the process on the same Sheet or another sheet the
results fails as described.

I will apprecite any help