2 Replies Latest reply: May 15, 2014 10:02 AM by Joe_ _ RSS

    Limit on Summaries?

    mcandrje _

      I'm having some problems with V9 and Windows XP exports.  I have a couple reports that have over 30 summaries in them, and they either export nothing (I can't even open the Excel file), or they export only part of the summaries and then I don't get detail on the rest of the tabs - I get only the salesperson number or row titles.  Is there a limit to the number of summaries one can export from a single report?  I have Excel 2003, and the file size is only 382KB.

       

      Thanks for any help!

       

      janet

        • Limit on Summaries?
          Grant Perkins

          Ho Janet,

           

          2 ideas based on a search in the 'archives'

           

          Are you exporting to Excel as a V9 export or a V8 export? (Search the forum using 'Summary Excel Export' for a list of possibly related challenges!)

           

          V9 has additional features but sometimes some people have found some problems exporting as V9.

           

          The other oddity has been something obscure related to the current default printer on the hosting PC ... reasons seem to be unidentified but changing the default printer has worked for some people with problems that sound kind of similar to yours.

           

          If neither of those work in your case we will have to continue to look for another answer.

           

           

          Grant

          • Limit on Summaries?
            Joe_ _

            I've spent the morning looking for a reason why all of sudden all of my exports (tables and summaries) were getting 'Unable to open' messages from Excel 2003.

             

            I had figured out I could turn off the excel formatting and at least open the file, but then had to reformat columns/headers and such.

             

            Checked again after lunch and found Grants response.  Among all the service packs, I installed last week I Never would have thought it would be related to my default printer.  Sure enough, I also changed printers last week, a quick change of defaults and I'm back in business.