Excel Tables in non-jet functions sheets get affected

I have the excel work book in which 4 sheets , of these 4 sheets only 2 sheets have the jet functions say one for the options and another for the report where we get values from the system with the jet functions, other two sheets pure excel sheets one for the "excel table data" in which most of the data is static except a few values referenced to jet functions sheet for the updated values, other sheet is for pivot table from the excel table data . after ensuring all the date in design mode when refreshed the data in pivot table and pivot table gets lost ???

Please some one help to keep the non jet functions sheets data intact.

Warm regards



Please sign in to leave a comment.