Remove data connection, keep PivotCache

With Excel 2010 a yellow warning bar is shown when opening a file with data connection. I don't want to show this warning to other users who will be opening the file, especially when they won't be able to update anything since the original data is on my computer. The logical way would be to remove or disable the connections before sending the file out. But when removing the data connections through Connection window all the pivot tables are converted to static tables, which is not acceptable. Is there any other solution to this? Maybe use a macro?
PS: I know that these warnings can be turned off though Trust Center, but I am not interested in changing these settings for other users.

Close all the excel workbooks and keep the Pivot workbook only and Press Alt+F11 and Press Ctrl+R to get the Project Explorer window>>Double Click This workbook>>Copy and paste the below code

Please Login or Register  to view this content.

Save the file and open and check whether it is prompting for any update. Checked it with external formula's and hope so it will work with pivot also.

Please let us know your feedback...