Error Code: 3241607174

Strange error, hmm !!

When you enable a scheduled data refresh on the workbook, you receive the following error message from the SQL Server Analysis Services instance: 

Error Code: 3241607174

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook, file File Name .

If you wanna resolve this issue then please convey MILLION THANKS to Microsoft as they have already published an article on this:

http://support.microsoft.com/kb/2761246   

How to enable the audit log in SharePoint 2013

To enable the audit log by using Central Administration

·         On the Central Administration home page,

·         In the Application Management section,

·         Click Manage service applications.

·         Select the Secure Store service application.

·         On the ribbon, click Properties.

·         From the Enable Audit section,

·         Click to select the Audit log enabled box.

·         To change the number of days that entries will be purged from the audit log file, specify a number in days in the Days until Purge field.

·         The default value is 30 days.

·         Click OK.

Configure audit settings for a site collection

Please use the following link in which Microsoft has given a very detailed description that references each and every minor point regarding audit settings:

It consists of:

·         Auditing event information

·         Trimming the audit logs (new enhancements in SP2010 and SP2013 as compare to earlier versions)

·         Configure audit log trimming

·         Configure events to audit

http://office.microsoft.com/en-us/sharepoint-help/configure-audit-settings-for-a-site-collection-HA102866204.aspx  

View audit log reports

Following link will help you to understand the following points:

·         Events available for audit log reports

·         Available audit log reports

·         View audit log reports

http://office.microsoft.com/en-us/sharepoint-help/view-audit-log-reports-HA102772739.aspx  

Please let me know in case of any queries/questions so that we can discuss and sort it out quickly.

Thank you

SharePoint Book Reviews

Here you can find various overviews of upcoming SharePoint 2013 books from O’Reilly published by Microsoft Press.
http://search.oreilly.com/?q=sharepoint+2013&x=0&y=0  

Downloadable eBook: Explore SharePoint 2013

Learn what’s new in SharePoint 2013 from this official ebook from Microsoft
http://www.microsoft.com/en-us/download/details.aspx?id=35396  

Downloadable eBook: Deployment guide for SharePoint 2013

Want to learn how to install and configure SharePoint 2013? This book provides deployment instructions for SharePoint 2013. It's aimed at application specialists, line-of-business application specialists, and IT administrators who are ready to deploy SharePoint 2013.
http://www.microsoft.com/en-us/download/details.aspx?id=30384