Hi folks, hope you're all well. I have a stupidly simple, yet frustrating, problem!
Background - I use Windows 10 and have been quite content with Excel 2007. I've been saving files as Excel 97/2003 version. I have a number of spreadsheets that I use for my (very) small business. One of them is used to create invoices - these are saved and then converted to pdf for emailing my clients. Recently, sany saved sheets have been opened as "compatability mode" - I'm afraid I have no idea why that is the case! However, I have noticed that - sometimes, not every time! - if I try to open a sheet from my desktop, it opens it in Excel Professional Plus 2016 and tells me the copy is not activated. I have no idea how to proceed from there but suspect I can't do anything to activate as I do not have any original software (my laptop was bought as a reconditrioned item a few years ago and came with MS Office already loaded).
Yesterday, I wanted to add an extra worksheet to my "invoice" workbook. But, I found that it was a) not possible to do this by right=clicking on another worksheet tab or b)by selecting "insert sheet" in the Home toolbar as it is greyed out. The "Review" toolbar shows that the neither the sheets or workbook are protected.
If you have a few minutes, please feel free to look at the attached workbook. It is basically the same as the one I want to add a sheet to, but with all "confidential" data removed to protect the innocent!
You'll see that some columns are hidden, and that some of the formulas use look-ups from a hidden sheet as well I'd quite like to "unhide" that sheet, but I can't seem to do that either!!
Thanks in advance for any help you can give me. I really appreciate it.
Mike
Bookmarks