A1 and A2 Missing also "Error 6 Overflow"

Question

Hi All,

On this excel sheet I have A1 and A2 seem to be hidden under the top where the top is., and also under where it's supposed to say "January 2019" Also when I click the little triangle under A1 I receive an error saying "Error 6 overflow" How can I fix this?

Answer 1

Zixuan, I fixed this issue by unfreezing the spreadsheet. Thank you.

Answer 2

Hi Kyle,

If Row 1 & 2 is hidden, you may try to select Row 3 and the column header row, right click and choose Unhide to see the outcome.

Meanwhile, regarding the error message you encounter, could you please make a copy of that file, repro that behavior and capture a screenshot of it? I found some related information about "Run-time Error '6': Overflow", and most of them are related to macro. Therefore, we would like to confirm whether you are running macro in that workbook as well.

Additionally, to better address it, we would like to collect more information.

1. Your OS version.
2. A screenshot of your Office Product Information.(File>Account, capture all the info under Product Information)
3. Please create a new workbook and click the little triangle. We'd like to confirm whether it persists in all the files.

Regards,

Zixuan

Answer 3

Hi Kyle,

Please post back with the above information when you have time. We will try our best to provide support for you.

Regards,

Zixuan

Answer 4

Hi Kyle,

Thanks for your update and sharing. It will be helpful for other community members who may encounter the similar behavior as you. 

Feel free to start a new thread in our forum if you have any other queries about Office 365 for Business services, we will be glad and try our best to provide support for you.

Regards,

Zixuan