Hi there

I use a syntax for exporting pivot tables to xls, xlsx and doc. Untill end of december it was running correct on my v26. As i was experiencing problems a few days ago, so ive installed v29.

Here is the syntax:

OUTPUT EXPORT
/XLS  DOCUMENTFILE= ' C:\destination.xls' .
OUTPUT EXPORT
/XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .
OUTPUT EXPORT
/DOC  DOCUMENTFILE= 'C://destination.docxx' .
     OUTPUT CLOSE *.

symptoms:

the output to xls and xlxs is correct an fluent

when it comes to export to doc, spss freezes. It takes minutes to perform the first export, and when it comes to the second pivot to export to doc, spss stops responding and needs to be restarted. 

I've re-installed spss v29 twice and reboot, but the symptoms persist. 

I'am on a i9 processor with 64gb RAM, so no problem with resources

Also, if i ask a pivot table using the menu, and re click, the submenu opens but, i can select export but nothing happens

thanks for any help

Hi. Do these all work correctly?

OUTPUT EXPORT /XLS  DOCUMENTFILE= ' C:\destination.xls' .OUTPUT EXPORT /XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .OUTPUT EXPORT /DOC  DOCUMENTFILE= 'C:\destination.docx' .OUTPUT CLOSE *.

** Note the changes made to the last OUTPUT EXPORT and OUTPUT CLOSE.

Hi there

I use a syntax for exporting pivot tables to xls, xlsx and doc. Untill end of december it was running correct on my v26. As i was experiencing problems a few days ago, so ive installed v29.

Here is the syntax:

OUTPUT EXPORT
/XLS  DOCUMENTFILE= ' C:\destination.xls' .
OUTPUT EXPORT
/XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .
OUTPUT EXPORT
/DOC  DOCUMENTFILE= 'C://destination.docxx' .
     OUTPUT CLOSE *.

symptoms:

the output to xls and xlxs is correct an fluent

when it comes to export to doc, spss freezes. It takes minutes to perform the first export, and when it comes to the second pivot to export to doc, spss stops responding and needs to be restarted. 

I've re-installed spss v29 twice and reboot, but the symptoms persist. 

I'am on a i9 processor with 64gb RAM, so no problem with resources

Also, if i ask a pivot table using the menu, and re click, the submenu opens but, i can select export but nothing happens

thanks for any help

Hi Rick

no, excel output works fine, word output makes spss to freeze.

Hi. Do these all work correctly?

OUTPUT EXPORT /XLS  DOCUMENTFILE= ' C:\destination.xls' .OUTPUT EXPORT /XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .OUTPUT EXPORT /DOC  DOCUMENTFILE= 'C:\destination.docx' .OUTPUT CLOSE *.

** Note the changes made to the last OUTPUT EXPORT and OUTPUT CLOSE.

Hi there

I use a syntax for exporting pivot tables to xls, xlsx and doc. Untill end of december it was running correct on my v26. As i was experiencing problems a few days ago, so ive installed v29.

Here is the syntax:

OUTPUT EXPORT
/XLS  DOCUMENTFILE= ' C:\destination.xls' .
OUTPUT EXPORT
/XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .
OUTPUT EXPORT
/DOC  DOCUMENTFILE= 'C://destination.docxx' .
     OUTPUT CLOSE *.

symptoms:

the output to xls and xlxs is correct an fluent

when it comes to export to doc, spss freezes. It takes minutes to perform the first export, and when it comes to the second pivot to export to doc, spss stops responding and needs to be restarted. 

I've re-installed spss v29 twice and reboot, but the symptoms persist. 

I'am on a i9 processor with 64gb RAM, so no problem with resources

Also, if i ask a pivot table using the menu, and re click, the submenu opens but, i can select export but nothing happens

thanks for any help

Well, I wanted you run my syntax, not re-run your own, because I made a couple of changes. That's OK. Let's assume my changes made no difference. Try this:

1. Close SPSS completely.
2. Open a command window (Look for cmd.exe)
3. In that window, type this:
   CD "C:\Program Files\IBM\SPSS Statistics"
   stats.com
4. Then, try your syntax again.
   Run all the commands down to the OUTPUT EXPORT DOC (that fails) first, and save the SPV file.
   Check the command window. There should be nothing there; at least, I don't expect SPSS to have written anything there yet.
5. Now, run the command that fails. While SPSS is hanging there and not answering, return to the command window and see if SPSS wrote something to it this time. I would like to know what it is, if so.
6. Can you please email me the SPV file so I can try it here? Thanks. marcantr@us.ibm.com

Hi Rick

no, excel output works fine, word output makes spss to freeze.

Hi. Do these all work correctly?

OUTPUT EXPORT /XLS  DOCUMENTFILE= ' C:\destination.xls' .OUTPUT EXPORT /XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .OUTPUT EXPORT /DOC  DOCUMENTFILE= 'C:\destination.docx' .OUTPUT CLOSE *.

** Note the changes made to the last OUTPUT EXPORT and OUTPUT CLOSE.

Hi there

I use a syntax for exporting pivot tables to xls, xlsx and doc. Untill end of december it was running correct on my v26. As i was experiencing problems a few days ago, so ive installed v29.

Here is the syntax:

OUTPUT EXPORT
/XLS  DOCUMENTFILE= ' C:\destination.xls' .
OUTPUT EXPORT
/XLSX  DOCUMENTFILE= ' C:\destinatrion.xlsx' .
OUTPUT EXPORT
/DOC  DOCUMENTFILE= 'C://destination.docxx' .
     OUTPUT CLOSE *.

symptoms:

the output to xls and xlxs is correct an fluent

when it comes to export to doc, spss freezes. It takes minutes to perform the first export, and when it comes to the second pivot to export to doc, spss stops responding and needs to be restarted. 

I've re-installed spss v29 twice and reboot, but the symptoms persist. 

I'am on a i9 processor with 64gb RAM, so no problem with resources

Also, if i ask a pivot table using the menu, and re click, the submenu opens but, i can select export but nothing happens

thanks for any help