If this is a really big deal, consider switching to a database backend that can take care of partitioning for you, like Oracle or SQL Server. Then leave partitioning disabled in the Ignition Historian configuration. When the backend handles partitioning, clients, including both Ignition and Excel, will just ‘see’ one big table.