Export form PivotTable, then Import into PivotTable

Programming and Web Development Forums - Microsoft OFFICE - Microsoft Office products

Skip to content

Export form PivotTable, then Import into PivotTable

Microsoft OFFICE
Post a reply

    Next

  • 1. help for owc chart line
    Dear All , Does Someone know how to display line uncontinuously . for example , below is 60 points X range from (1..100) , Y range from (1,200) no two points have the same X value, object : connect the neighboor points by line in OWC neighboor means : two points P1(x,y) ,P2(x,y) so P1.x - P2.x = 1 or -1 Thanks
  • 2. My OWC's Spreadsheet is not displayed
    Could you help me I have a PivotTable web using OWC. It works well when it's being accessed by users from the same network segmen But when the PT is being accessed by users form another segmen/domain, the object become dissappear without any confirm (even I have added the address on IE's the trusted site).
  • 3. Question about TickLabelSpacing and linegraphs
    If someone could help me with these problems, it would be great!. I tried many, many before i got here, but couldn't get it right 1) I want to print X-axis values on intervals if the number of X-labels becomes too large. So i use TickMarkerSpacing and TickLabelSpacing and it works fine. But one problem is that i would like the *first* label (btw. the x-values i use are dates ) to be displayed on the *first* x-value at the graph and don't want OWC control it himself where the first tick/label gets placed. Is there a workaround for this 2) Maybe a but difficult to explain, but In a bargraph which displays certain values, I want to show one LINEgraph as well, in a certain color. this line has to 'follow' the exact widths of the rest of the bargraph, so just as a square-block like the way the bargraphs are displayed so to say. Now i cannot get this to work, because this graph just makes straight lines from the first point to the second to the third etc.etc. and this is not what i want. I want it tio be a block graph, but it *only may have* an outline , so it *stays* a line in the graph ands is not being displayed exactly like a bargraph (=with vertical lines all the way down to the x-asis as is the way a bargraph is displayed). So i only want this line to act as a sort of 'trend' so to say I hope its a little bit clear what i need Thx in advance
  • 4. pivot table chart not showing in table cell
    I'm displaying data warehouse cube "views" in a web page (published from an Excel Pivot Table via Office Web Components). When I just show one, I can see the chart just fine. If I want to show more than one slice of the cube, I can do that in frames, and the display is as expected. However, if I abstain from frames and try to show it in a table, the chart won't show. I do see that I can hook a chart by itself to a flattened recordset via ADO, but that's not what I'm looking for. I want to be able to show the chart (and table) as published to a webpage from Excel, and I want to be able to show that chart in a table cell. I also want to be able to show just the chart and size it as needed, if possible, without having to do real coding behind the scenes. The pivot table shows up just fine; why not the chart, especially since the chart DOES show when it's not in a table cell. Any insight? TIA
  • 5. Chart Borders
    Is there a way to remove the border from around a chart? Border.Weight = 0 Still produces a thin border. Thanks

Export form PivotTable, then Import into PivotTable

Postby Rycho » Sat, 12 Nov 2005 01:49:21 GMT 

Hi there,
I'm connecting PivotTable to OLAP Cube on the server:
<script language="VBScript">
OLAPProvider = "Provider=................"
OLAPCube = "Sales"
 Function start()
   PivotTable.ConnectionString =  OLAPProvider
   PivotTable.DataMember = OLAPCube
 End Function
</script>

then i'm building "my PivotTable" and here is a question:
how to export it to xml file whitch can be imported once again?
when i'll export it to Excel, it's building PivotTablexxxx.HTM file in
Temp, then Excel is reading this file, but how to import it into blank
PivotTable?
When i'm trying to import this file there is an error: Error opening
data file "file://c:\myfile.htm"
to import this file i'm using this script:
<script language="VBScript">
providerPivotTable = "provider=mspersist"
strdirname = "c:\myfile.htm"
 Function start()
   PivotTable.ConnectionString =  providerPivotTable
   PivotTable.CommandText = strdirname
 End Function
</script>

What's wrong with this? Any ideas?
I have tried also to save this file from excel in .csv and .xml format,
but it's not working anyway.
Please help,
Richard
Top

Similar Threads:

1.Problem of PivotTable Form Export to Excel 

Dear all,

I have a PivotTable Form created with calculated total (generated by 
alculated Totals and Fields.  That fine if showing by PivotTable View 
but if I export it to the Excel, the calculated total disappeared on the 
Excel side.

Is it a limitation of Access Form or I have something wrong with the Form?

Thanks a lot in advance.

2.Export PivotTable Form To Excel without Preview 

Dear all,

Is it possible to export a PivotTable form directly from Macros without 
"OpenForm" action?  (User will need to select "Export to Microsoft Office 
Excel" if export in this way.)

Thanks!

3.Creating a PivotTable Report from an Another PivotTable Report 

When you begin the pivot table wizard there are a total of four choices under 'What is the data you would like to analyze?'.  The fourth (Another PivotTable Report or Pivot Chart Report) is the one that i would like to use and the option button is always greyed out and you are unable to select it.  How do I go about making it possible for me to select this option.  I am using Microsoft Excel 2002.  Can anybody help me

4.Creating a PivotTable w/o selecting data in an existing PivotTable 

I am attempting to create a second PivotTable using the PivotTable Wizard and 
need to use an Excel database as my data source. Each time I select the data 
range and hit Next it gives me a list of PivotTables to choose from for my 
data source. Excel should be giving me the option to create the table from an 
existing table (as it is) to save memory or choose a new data source. If I 
use another machine in the office it does give me this option. Is there any 
way to get my computer to give me this option? I appreciate any help.

5.Creating a PivotTable Report from an Another PivotTable Report 

When you begin the pivot table wizard there are a total of four choices under 'What is the data you would like to analyze?'.  The fourth (Another PivotTable Report or Pivot Chart Report) is the one that i would like to use and the option button is always greyed out and you are unable to select it.  How do I go about making it possible for me to select this option.  I am using Microsoft Excel 2002.  Can anybody help me?

6. PivotTable - PivotTable Field name is not valid - error!

7. Creating a PivotTable Report from an Another PivotTable Report

8. PivotChart Form by manipulating PivotTable, ChartSpace & RecordSou

Post a reply

Return to Microsoft OFFICE

 

Who is online

Users browsing this forum: No registered users and 56 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group