Exported search results won't 'send to new document' or 'paste into open document&#3

I am having trouble exporting search results to MS Excel. I can export simple searches into MS Word, but I need the functionality of 'Analysis' search results and these can only be exported in table form to Excel. I am able to save an XML file with the search results and then convert that file - but this is a slow and complicated way around.

Running Windows 10 and Office 365 Pro 32 bit version

Zipped log file attached

All help very gratefully received.

Find more posts tagged with

Comments

Fred Chapman

Are you saying that you have the option to export the results to Excel, but it does not work? or Are you saying the option to export to excel is not present?

I did a search on the word grace in the ESV and selected Analysis view. It exports fine to Excel 365 and sends the results in the same format as analysis view. I also tested it in verse view and it exports to Excel in the same format as shown on the Verse view screen. Can you be more specific about the trouble you are having.

Simon Gillham

https://community.logos.com/discussion/comment/994881#Comment_994881

Thanks Fredc. I have the options, but when I click the options nothing happens

Dave Hooton

https://community.logos.com/discussion/comment/994883#Comment_994883

Did you try "Save as... Spreadsheet"; which works for Excel? "Send to new... Excel" will fail.

Simon Gillham

https://community.logos.com/discussion/comment/994899#Comment_994899

Thanks Dave. Yes, I can 'save as' an XML file and then open that in Excel. I end up with a lot of separate files that I then work with and convert to save. That is OK, but I was just wondering if it is possible to get the more efficient options to work.

Dave Hooton

https://community.logos.com/discussion/comment/994981#Comment_994981

wondering if it is possible to get the more efficient options to work.

I'm afraid not.

Bradley Grainger (Logos)

https://community.logos.com/discussion/comment/994986#Comment_994986

wondering if it is possible to get the more efficient options to work.

I'm afraid not.

If I'm correctly understanding what you want to do, it works fine on my computer.

Logs might help show what's going wrong.

Bradley Grainger (Logos)

https://community.logos.com/discussion/comment/994899#Comment_994899

"Send to new... Excel" will fail.

As I just posted, this option works for me; why do you think it "will fail"?

Dave Hooton

https://community.logos.com/discussion/comment/995070#Comment_995070

There have been bug reports about this feature, and it still doesn't work in Excel 2016 (Office 365).

Fred Chapman

https://community.logos.com/discussion/comment/995229#Comment_995229

I have not tested this on my Desktop PC, but sending the analysis results to Excel does work on my Macbook running Office 365. I wonder if the fact the OP is running Office 365 32 bit has anything to do with the problem.