Error exporting pivottable to excel

[Rafael]

I have an application that I use OWC 10 and when I try to export to excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Alvin Bruney - ASP.NET MVP]

it's most likely a permissions issue. have a look at your event logs to see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Rafael]

I searched at the event log but there was nothing on it.

Otherwise, excel created at c:\temp a file called htmlerr.log and I founf
this:

XML ERROR IN PIVOTTABLE
REASON: Incorrect Value
ACTION: Ignoring mark
FILE: C:\TEMP\rad19986.tmp
GROUP: PTRule
TAG: Rule
VALUE: '[Centro de Custo].[Centro
Custo]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count
Nums',StdDev,StdDevp,Var,Varp]

Any ideas?

Thanks for your help!

it's most likely a permissions issue. have a look at your event logs to see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an application that I use OWC 10 and when I try to export to excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Alvin Bruney - ASP.NET MVP]

You obviously have some incorrect data somewhere. Start by trying to export
a file with one or two elements and work you way up from there.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I searched at the event log but there was nothing on it.

Otherwise, excel created at c:\temp a file called htmlerr.log and I founf
this:

XML ERROR IN PIVOTTABLE
REASON: Incorrect Value
ACTION: Ignoring mark
FILE: C:\TEMP\rad19986.tmp
GROUP: PTRule
TAG: Rule
VALUE: '[Centro de Custo].[Centro
Custo]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count
Nums',StdDev,StdDevp,Var,Varp]

Any ideas?

Thanks for your help!

it's most likely a permissions issue. have a look at your event logs to see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an application that I use OWC 10 and when I try to export to excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Rafael]

Ok, i´ve made some tests and that´s what happens:

-When I do not have any dimension, just data the problem doesn´t happen.
-If I put any dimension the problem comes up.

I could not figured out what´s going on. Somebody can help me??

Thanks!

You obviously have some incorrect data somewhere. Start by trying to export
a file with one or two elements and work you way up from there.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I searched at the event log but there was nothing on it.

Otherwise, excel created at c:\temp a file called htmlerr.log and I founf
this:

XML ERROR IN PIVOTTABLE
REASON: Incorrect Value
ACTION: Ignoring mark
FILE: C:\TEMP\rad19986.tmp
GROUP: PTRule
TAG: Rule
VALUE: '[Centro de Custo].[Centro
Custo]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count
Nums',StdDev,StdDevp,Var,Varp]

Any ideas?

Thanks for your help!

it's most likely a permissions issue. have a look at your event logs to see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



I have an application that I use OWC 10 and when I try to export to excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Rafael]

Some other tests:

1)
When I export the pivot table to excel, a xml temp file is created. If I
just remove the lines that appeared at the error log file manually from this
file and open this file in excel the problem doesn´t happen.
If I create a script that remove this every time before I export to excel,
will have some problems like losing data?

2)
I was under Win XP and Office 2003 and exported to excel fine. A saved the
xml file and opened at the Win NT 4 and Office 2000 and the same problem
happened!

I´ve tried everything! Somebody can help me please????

Ok, i´ve made some tests and that´s what happens:

-When I do not have any dimension, just data the problem doesn´t happen.
-If I put any dimension the problem comes up.

I could not figured out what´s going on. Somebody can help me??

Thanks!

You obviously have some incorrect data somewhere. Start by trying to export
a file with one or two elements and work you way up from there.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I searched at the event log but there was nothing on it.

Otherwise, excel created at c:\temp a file called htmlerr.log and I founf
this:

XML ERROR IN PIVOTTABLE
REASON: Incorrect Value
ACTION: Ignoring mark
FILE: C:\TEMP\rad19986.tmp
GROUP: PTRule
TAG: Rule
VALUE: '[Centro de Custo].[Centro
Custo]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count
Nums',StdDev,StdDevp,Var,Varp]

Any ideas?

Thanks for your help!

:

it's most likely a permissions issue. have a look at your event logs to see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



I have an application that I use OWC 10 and when I try to export to excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Rafael]

That´s what I found now:

I have this tag where the problem occurs:

<x:Rule>'[Empresa].[Empresa]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count Nums',StdDev,StdDevp,Var,Varp]</x:Rule>

If I delete manually the parameters StdDev and StdDevp it just work!

Now, I can´t figure how can I make this work in the application without
deleting this manually!

Some other tests:

1)
When I export the pivot table to excel, a xml temp file is created. If I
just remove the lines that appeared at the error log file manually from this
file and open this file in excel the problem doesn´t happen.
If I create a script that remove this every time before I export to excel,
will have some problems like losing data?

2)
I was under Win XP and Office 2003 and exported to excel fine. A saved the
xml file and opened at the Win NT 4 and Office 2000 and the same problem
happened!

I´ve tried everything! Somebody can help me please????

Ok, i´ve made some tests and that´s what happens:

-When I do not have any dimension, just data the problem doesn´t happen.
-If I put any dimension the problem comes up.

I could not figured out what´s going on. Somebody can help me??

Thanks!

You obviously have some incorrect data somewhere. Start by trying to export
a file with one or two elements and work you way up from there.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



I searched at the event log but there was nothing on it.

Otherwise, excel created at c:\temp a file called htmlerr.log and I founf
this:

XML ERROR IN PIVOTTABLE
REASON: Incorrect Value
ACTION: Ignoring mark
FILE: C:\TEMP\rad19986.tmp
GROUP: PTRule
TAG: Rule
VALUE: '[Centro de Custo].[Centro
Custo]'[All;Total,Sum,Count,Average,Max,Min,Product,'Count
Nums',StdDev,StdDevp,Var,Varp]

Any ideas?

Thanks for your help!

:

it's most likely a permissions issue. have a look at your event logs to
see
if there are any error messages in there. that will give you a start on
where to concentrate your digging.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



I have an application that I use OWC 10 and when I try to export to
excel
2000 the following erro occurs:
" Problems came up in the following areas during load:

PivotTable "

This just happens when I am under Windoows NT 4.

I tried with Win XP and Excel 2003 and this error didn´t happen.

Somebody knows why this happen?

Thanks!

 

[Richard Ch]

you can remove it from a code like:
----------------------------------------------------------------
set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.async = "false"
xmlDoc.loadXML(pivottable.XMLData)
for a=0 to xmlDoc.documentElement.getElementsByTagName("x:Rule").length
-1
set test =
xmlDoc.documentElement.getElementsByTagName("x:Rule").Item(a)
test.text = ""
set test = nothing
next
and then
pivottable.XMLData = xmlDoc.xml