Excel inplace show empty because its due to "Macro" settings.

 

 

1.     1. Click the Microsoft Office ButtonButton image, and then click Excel Options,.

2.     2. Click Popular, and then select the Show Developer tab in the Ribbon check box.


3.     3. Now you are able to edit macro settings. Go to Developer tab


4.     4.Check Enable all macros & Trust access to VBA project.

5.