Hi evry one,
I have problem with refreshing excel pivot report. here is more information.
The excel pivot report fetching the data from sql server. i have created one VB script to refresh that report from SQL job, just add as step. my problem is intial i got the error like "file being used or not in location, etc..." then i have followed and changed the Excel application properties to "Intractive user" mode. now my problem is after setting intractive option the script is executing if me or some one login to server. if no one login to server the job getting fail.
Could you please help me how to solve this problem.
Thanks in advance.
Regards
Shank