We are using the Professional edition of Salesforce. We have been using excel connector to attach pdf reports to various accounts. Some of the base 64-encoded PDFs exceed the 32K limit in Excel. The account shows the report name under attachments but when you try to view it you receive a message indicating the file is corrupt. Has anyone found a way around this limitation or come up with another way to add attachments?
I have been trying to add attachments using excel connector and am having some problems. I enter 'new' under Attachment, the directory path under Body, the file name under File Name, the Parent ID, and the Content Type is application/msword. When I insert the row, it shows as an attachment under the Account but it will not allow me to open the file.
I've been trying to use the Excel Connector for the last two weeks to manage the data in our organisation, but I'm having a problem where I get the following error in Excel which is preventing me from using this tool:
The first couple of times I tried to use Excel Connector it worked fine. However I then started seeing this error every time I tried to use it - the error appears after I put in my password in Excel Connector and click Login.
We are on Salesforce Professional. I have tried uninstalling and reinstalling the toolkit and connector, but it hasn't made a difference. I'm using Excel 2010 32-bit on Windows 7 64-bit.
I can log in to Salesforce in my browser on the same computer.
I've checked that IE is not in Offline Mode, and verified that Excel can actually connect to the internet (pinged a URL using VBA script).
I've tried disabling my antivirus (MSE) and windows firewall.
I've tried changing the server url as suggested by this thread (had to modify registry keys to do this as that field was not editable in the connector.
None of these resolutions worked.
Has anyone experienced and managed to resolve this, or can anyone suggest any other possible resolutions?
