Option To Split Inventory and Other Reports Into More Than One Workbook
Hi Guys, when perform an Inventory that returns more than Excel's (2007 onwards) maximum supported limit of 1,048,576 rows, any row beyond this is trimmed. Maybe provide an advisory on this &/or an option to split the inventory into more than one workbook so that it'll work? Cheers, Andy Talbot (Microsoft MVP - Office Apps & Services)
Helge Wagner commented
Create a report with 2.500.000+ results (item permission) - ShareGate create it fine and export it as Excel - however excel can only open 1.500.000 rows (approx)
When exporting a lot of metadata, some users hit the row limit with Excel and get an error. Some would like for Sharegate to be able to work around that and automatically create multiple files.