Colleague can't export to excel but I can, why?

[#1]

Hi,

I've a QV document on my desktop that makes an export to excel. When my colleague uses the same document, it doesn't make the export.

I've been looking in the user preferences, but I can't find anything that might cause this.

What can be the result of this?

Thanks,

Guido

[jjfabian]

Hi Guido,

have a look here:

Document Properties --> Security --> "Allow Export"

[Anonymous]

Guido,

Two possible reasons I can think of at this moment:

1. He doesn't have Excel

2. Export to Excel is using a macro, and your colleague didn't allow system access for macros.

Regards,

Michael

[#4]

It's turned on.

[Anonymous]

Jakob,

It is also a possibility.  But that means that the QV document is not the same in this case.

Regards,

Michael

[#6]

He does have excel and when he runs the macro, he gets the message "Exports Done"

The macro:

Sub Export

file="Employee.xls"

set Chart2Export = ActiveDocument.GetSheetObject("TB01")

Chart2Export.ExportBiff file

MsgBox "Exports Done!"

End Sub

[Anonymous]

Looks fine, no system access needed...

What happens if he tries to export by right-click on the chart and send to excel or export?

[#8]

He can send the table to excel that way.

[Anonymous · Accepted solution]

Well, something with the macro.  Does he have that Employee.xls file?  Maybe he needs to specify the full path to the file.

Edit: I tried your macro.  It didn't work as is (only produced the message at the end), but worked after I changed to the full name with path.

[#10]

Thanks! That was the solution. Still strange that it works on my desktop but not his.