I am by no means an Excel Guru or all that knowledgeable about Excel - I use it daily and can function in it well enough for what I need to do day to day.
My father in law has run into an issue with an Excel spreadsheet that he needs to utilize for work.
The workbook itself is password protected - so I do not really have the ability to edit or attempt to manipulate in hoping to resolve the problem.
The problem being that there are a series of merged cells that include a series of multiple choice answers (A., B., C., and D.) but on his PC in Excel 2010, B. and C. are missing - only A. and D. are shown.
When I open the Excel workbook in Excel 2013 on my PC, it displays everything fine. I've attached two screenshots - one of the data showing correctly in Excel 2013 and one of the data not being shown in Excel 2010.
Others at his workplace utilizing Excel 2010 do not have this issue and they spent several hours yesterday working on it but seem to think it may be an issue with his PC as they are not experiencing the issue.
Bookmarks