Since you did not provide details or answer to my questions, then based on my experience I assume that you have chosen the approach not suitable for your needs.
Excel limitation on the number of records in the worksheet, it was discussed a number of times here. See for example thread #
778968 for details, explanation and solutions.