topic Re: File exported in Excel not modifiable in QlikView

File exported in Excel not modifiable

Wed, 30 Dec 2015 18:14:06 GMT

Hi all,

when I export a table from Qlik (8.5) to an Excel 2010 the file is not modifiable.

The multifuction bar seems disabled and is not clickable.

I've compared the Excel protection settings of this computer with those of another computer where the export works correctly but they seem the same.

Where is the problem according to you?

Claudio

Re: File exported in Excel not modifiable

Thu, 31 Dec 2015 15:27:38 GMT

Claudio

I am not sure what you mean by multifunction bar - are you referring to the toolbar in Excel?

since I do not have version 8.5, any testing I would do would not be valid - there are export option in settings/user preferences/export but those options would be the same for all users

is it possible to post the excel file?

if you cannot post the file, can you post a screen sample of what is disabled?

Re: File exported in Excel not modifiable

Peter_Cammaert — Thu, 31 Dec 2015 15:39:01 GMT

Probably in Excel.

On the problem machine, does Excel display a yellow notification bar at the top (stating that editing has been disabled)?

Best,

Peter

Re: File exported in Excel not modifiable

Thu, 31 Dec 2015 15:46:48 GMT

that was my thinking - the file is being created read only or is somehow getting marked as final version - both of those items will place the yellow bar at the top

also, if you go the the File Menu, is the save as icon selected, and next to it does it say Read-Only workbook?

Re: File exported in Excel not modifiable

Thu, 31 Dec 2015 17:44:48 GMT

The bar at the top of the program. I mean the new menu bar with buttons. The file works on other computers so I think the problem is related to a setting of Excel on that pc.

Re: File exported in Excel not modifiable

Thu, 31 Dec 2015 17:46:45 GMT

Now I don't have here that pc, but there was a message saying that the file was opened in caompatible mode. But the same message appears also on the pcs where the same file is modifiable.

Re: File exported in Excel not modifiable

Thu, 31 Dec 2015 17:48:04 GMT

I can't choose the File voice of the menu beacause that menu is disabled.