Announcement

Collapse

Information Needed

See more
See less

Downloaded Reports not showing any information in Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Downloaded Reports not showing any information in Excel

    Just found another more pressing problem. When I go to download any report for the Reports link on the main page, it downloads and opens Excel but there's no information- it's a blank page. If I download the file first and try to open with Excel, it shows me a blank worksheet. If I download the file and open as a Word doc, the information is there. Checked multiple events, all the same result. This is a PRIMARY function for me and needs to be resolved soon.

    Org ID: 00D1a000000ZcBb

    Thanks.

  • #2
    Good day @michaelc,

    Would you please share the Event name which you are referring to? We downloaded the reports from couple of your Events and found NO issues.

    Looking forward to hearing back from you.

    Thanks,
    Regards,
    Click & Pledge Support Department

    On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

    Join us @ the educational webinars: https://clickandpledge.com/webinars/
    Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
    Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

    Comment


    • #3
      It's ANY event. I even had a coworker try this from a different location and she had the same result. I just tried Portland July 30th. Total blank Excel screen.

      Comment


      • #4
        Good day @michaelc,

        Strange! We don't have any issues with downloading any report from your Events. We have downloaded the Registrant & Attendee report from the Event which you are referring and found NO issues:

        Click image for larger version

Name:	Alpha Report.jpg
Views:	12
Size:	99.0 KB
ID:	25020

        It seems to be issue with your PC or excel you have in your system. NO client has been reported above issue nor we have able replicate it in all of our test instances.

        Please check and let us know if we can be of any further assistance.

        Thanks,
        Regards,
        Click & Pledge Support Department

        On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

        Join us @ the educational webinars: https://clickandpledge.com/webinars/
        Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
        Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

        Comment


        • #5
          So it's me and my and my associate using a different OS and different version of Excel logging in from a different network 200 miles away? I'm using Office 2010 on Windows 8.1. I've not had this issue before. This is the first time I've downloaded reports since your latest upgrade. Can I share my screen with someone there, possibly?

          Comment


          • #6
            Here's what I'm seeing:
            Attached Files

            Comment


            • #7
              Good day @michaelc,

              You may can join us at office hours where we can share the screen and see whats going on. Here are the Office hours details:

              Office Hours & Live Support Mon-Thu [3:00 - 5:00 p.m. EST] - Register once & attend any day: http://clickandpledge.com/webinar/

              Thanks,
              Regards,
              Click & Pledge Support Department

              On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

              Join us @ the educational webinars: https://clickandpledge.com/webinars/
              Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
              Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

              Comment


              • #8
                I'm traveling all next week and need to have functionality before then. I s there a support number I can call? Even a pay support line? If you had a conference available today I could join.

                Comment


                • #9
                  Good day!

                  It is strange. I tested this with Office 2016 Excel and it shows what you show but when I tested this with an older version of Excel it works fine. Quite strange, given the output is not something written by us but a native feature of Salesforce.

                  I found a solution in the interim. I opened the file without any issues using Google Docs / Sheets. I find it a bit strange that the output is not working as it was working before. I wonder if Salesforce has made any changes. I have asked our team to test this and figure out what is going on. Sorry for the problem-- I was testing this on a test machine with an older version of Office without any issues but with Office 2016 I see the same result as you.

                  Do you think you can use Google Sheets for now? I will update this thread once we have determined why this has started happening.
                  Regards,
                  Click & Pledge Support Department

                  On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                  Join us @ the educational webinars: https://clickandpledge.com/webinars/
                  Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                  Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                  Comment


                  • #10
                    Can you provide the procedure you used to open in Google sheets? I downloaded and then tried to upload using Google sheets, but that didn't work. Thanks.

                    Comment


                    • #11
                      Good day michaelc

                      Please open Google Sheets with a blank document and follow the steps:
                      1. Click on File > Open
                      2. Click on the Upload

                        Click image for larger version

Name:	2016-07-14_13-22-41.jpg
Views:	12
Size:	40.8 KB
ID:	25043
                      3. Drag the file, downloaded from event, and place it in the upload section
                      Click image for larger version

Name:	2016-07-14_13-25-48.jpg
Views:	11
Size:	114.8 KB
ID:	25044


                      & it opens without any issues.

                      I have also researched this and see a lot of posts in Microsoft sites regarding this issue. I will update this once we have an answer.

                      Strange..
                      Regards,
                      Click & Pledge Support Department

                      On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                      Join us @ the educational webinars: https://clickandpledge.com/webinars/
                      Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                      Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                      Comment


                      • #12
                        Good day!

                        Interestingly (I guess it is expected) - when the file is open in Google Sheets you can save it as Excel and then it opens up without any issues in Excel.

                        Research continues..
                        Regards,
                        Click & Pledge Support Department

                        On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                        Join us @ the educational webinars: https://clickandpledge.com/webinars/
                        Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                        Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                        Comment


                        • #13
                          @Good day michaelc

                          Found the problem... I am not sure this is your issue but it worked for me.

                          Earlier this week Microsoft release the Patch Tuesday and office update. In my instance, having the same issue as reported by you, the computer was updated to the latest Office Patch. I believe the patch had corrupted the instance.

                          In many forums the issue has been reported and the solution is a complete repair of office.
                          • Open the Control Panel
                          • Right click on office and choose Change
                            Click image for larger version

Name:	2016-07-14_13-57-26.jpg
Views:	12
Size:	14.9 KB
ID:	25049
                          • Select Online Repair -- I tried Quick Repair first but it did not work. Using the "Online Repair" worked.
                          • Once completed try to open the file
                          Click image for larger version

Name:	2016-07-14_13-51-44.jpg
Views:	11
Size:	115.2 KB
ID:	25048




                          I did this and it works now. The file opens without any issues.

                          Strange indeed. it is not a Salesforce issue but a corrupted file association with Office.

                          Please try it and let us know if this works.
                          Last edited by CnP.Support; 07-14-2016, 01:09 PM.
                          Regards,
                          Click & Pledge Support Department

                          On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                          Join us @ the educational webinars: https://clickandpledge.com/webinars/
                          Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                          Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                          Comment


                          • #14
                            I tried doing as you suggested but I don't get an online repair option. (see image) The regular repair option didn't work. I'm running Windows 8.1.
                            Attached Files

                            Comment


                            • #15
                              Good day!

                              The image you uploaded is a PNG. May I ask that you post a JPG file. This forum shows PNG files as thumbnail and not easy to see.

                              Did you go to the Control Panel > Programs & Features > right click on the Office application?
                              Regards,
                              Click & Pledge Support Department

                              On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                              Join us @ the educational webinars: https://clickandpledge.com/webinars/
                              Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                              Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                              Comment

                              Working...
                              X