I have tried several work arounds, PC's etc, checked all the forums, I'm at a loss.
I have pasted an Excel table into PowerPivot table. When I add subsequent months of data, via Paste Append, (using the exact same format as the initial table) to the existing table, everything works fine.
However...