function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
nsirotansirota 

Refreshing Reports w/ SF Office Edition (Excel)

Hello SF Community,
I am using the Salesforce office edition plug-in for excel.  I am not using excel connector, yet.
In any case, the question I had was this.  I imported several reports onto several worksheets in my excel workbook.  If I modify any data in any of the cells, and then hit refresh all sheets, will this update the salesforce database, or will it overwrite any changes in the spreadsheet with data from sf database?
 
I would normally play around to find the answer, but I am working with live data and cannot afford to miss anything or have anyone report an incorrect value.
 
Thank you,
~nsirota
wsws
Hi,
 
When you refresh your reports with Office Edition with Excel, any data you changed will be overwritten.  To put this another way, Office Edition only transfers data from Salesforce.com to Microsoft Excel.  It does not support bi-directional transfer of data.
 
I hope this helps.
 
Thanks,
 
forceAMPforceAMP

Bi-directional access using Excel is what QueryAmp is all about. Check it out on the AppExchange.