excel limits

  1. T

    Excel Table Exceeds Rows - Options for Pivot Tables

    I need to create one pivot table for a report. My data currently exceeds the rows for excel, so I took the data and put it on different tabs. The headers are the exact same, but instead of one tab with ~1M+ rows, I have two tabs with ~500K. How can I connect these two tables to one pivot...
  2. M

    Excel limitation or formula (sumproduct with multiple criteria) #Value problem?

    EDIT: I tried changing SUMPRODUCT to just SUM and that works. How do I make SUMPRODUCT work to get the output I need? Hi all, I've got a long SUMPRODUCT formula to search through a big database and sum the range of cells that match all criteria. I've checked all individual components of my...
  3. M

    Out of memory

    Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am busy bodily creating loads and loads of reports statistics on multiple worksheet. At one time I am even going through a large loop creating 30-40 worksheets i.e. for all business...

Some videos you may like

This Week's Hot Topics