Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Copy from excel export changes color


when I export a table from an app which is on the qlikview server to excel and then copy the table or a part of this table to a new excel document the background color changes to this ugly cyan color.

When I export an excel from development this issue does'nt appear.

I guess this is a server setting or is it excel issue?


Thanks for your help,


3 Replies
Creator III
Creator III

Hi Sebastian,

This is not a Qlikview issue. I have not come across such a thing before. This might be your Excel issue, the green triangle on the cells indicate error in the formula, you might want to hover or click on the green triangle & check what the issue could be or maybe there is a predefined setting.

Contributor II
Contributor II

Yes, I'm having the same issue.  Currently looking for a solution, too.

Edit: You can try this: upon pasting, right-click and select Match Destination Formatting

Pasting from Excel to Excel.png

Creator II
Creator II

It also works for me when I choose 'Paste Special' then 'Values & Source Formatting'