Déardaoin, 21 2018 Meitheamh
  2 Freagraí
  Cuairteanna 4.4K
0
Vótaí
Undo
I am trying to combine all the sheets of my workbook into one sheet.

I have multiple sheets with the same data format that I am wanting to combine, I followed the instructions to the letter, yet everytime I try to combine them, the new workbook is blank. I have tried multiple permutations of the combine options and all of them come back blank.

Is there something that I am fundamentally doing wrong, maybe there is something wrong with my data? Its just columns with Supplier name, category, item Name, Quantity, price and total. Each sheet is per supplier and using the same format.

I do get a Remark in the second workbook that opens "Exception from HRESULT: 0x800A03EC" I am not sure what this could mean.

I am hoping someone can help as this would save me a bit of time


Go raibh maith agat
blianta 5 shin
·
#1646
0
Vótaí
Undo
Ignore this post.
Figured out that one of my sheets had a huge amount of blank rows it was trying to combine. It was exceeding the maximum workbook size.
blianta 5 shin
·
#1647
0
Vótaí
Undo
Raibh maith agat as do chuid aiseolais. :)
  • Page:
  • 1
Níl aon fhreagraí déanta don phost seo go fóill.