If by "tabs" you mean "worksheets", the number in a workbook is limted by
memory, rather than by any arbitrary limit in Excel.

You say "it is erroring", but it may be better if you tell the group exactly
what error message you are getting.
--
David Biddulph

"Zakynthos" wrote in message
...
I need to import a large amount of data (of unknown size) into Excel.
Each item of data needs to go on a new tab - and when attempting the
import
it is erroring.

What is ther maximum number of tabs I can create in an Excel spreadsheet?

many thanks