Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 21 June 2018
  2 Replies
  4.1K Visits
0
Votes
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


Thanks
5 years ago
·
#1647
0
Votes
Undo
Thanks for your feedback. :)
5 years ago
·
#1646
0
Votes
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.
  • Page :
  • 1
There are no replies made for this post yet.