I decided to start taking notes and track our daily expenses by creating a CASH FLOW template via Microsoft Office Excel 2007.
So I started making the template until I found out that I couldn't bring the "Additional Controls" window out. After I right click on the toolbox and select additional controls, nothing happens. I can do this smoothly on my print shop's PC, but I can't do this on my home computer and it frustrates me. I have been troubleshooting this issue for almost a day now. I'm trying to achieve this so I can create a calendar popup within my Excel sheet. So I searched all over the internet for a solution but I couldn't find any. As far as my searching goes, I went ahead and cleaned my registry, registered some .dll files, ran Excel as Administrator, installed Excel add-ins, updated Windows 7, restarted Office 2007 and my PC, followed some advice/workarounds online yet still nothing ever worked. But with all the search that I have done, there was always one common factor to this issue, Windows USER PROFILE. I was about to give up, but I tried something for the last time. I changed the compatibility mode in Excel for Windows XP Service Pack 3, then it fixed it!
My PC build:
Windows 7 64 bit Service Pack 1
Microsoft Excel 2007
What I did was right-clicked on my Excel 2007 shortcut icon, the selected properties. This window will popup right after.
Make sure you select "RUN THIS PROGRAM IN COMPATIBILITY MODE FOR WINDOWS XP SERVICE PACK 3". That fixed the issue. At least to my computer. I hope this little trick will also help others that are having the same issue. I'd be happy to know if this helped you, just leave your comments below or give it a +1. Thanks!
Finally a solution!! Thanks for posting this... have been looking for hours how to fix this.
ReplyDeleteYou're welcome! Glad that it helped you.
DeleteThank you soooo much. even though i installed office common controls not worked. fortunately found this post and try it. It worked.
ReplyDeleteThanks lot......
It is very good.....A+++
ReplyDeletewaw, more years ago without hope, i designed all of my controls, spent more times to do that
ReplyDeletebut all my controls not like the original ... very very thnks.
Thanks A Lot !!!! Was struggling this for Months !! Great Solution. Cheers
ReplyDeletethanks
ReplyDeleteThank you all for your comments :) Glad to know I've helped somehow.
ReplyDeleteThanks to the solution
ReplyDeleteWhoever you are ........Blessings from me and many other users
ReplyDeleteGreat Job. Thx dude.
ReplyDeletethank very much
ReplyDeleteThank you so much
ReplyDeleteThanks a lot ,Finally it works :)
ReplyDeleteThis seems to have worked for a lot of people in the past but now with the advent of Windows 10 and Microsoft Office 2016, the same problem arises without the capability to "run compatability mode". Now Windows 10 only has "troubleshoot compatability" which is one of those useless surface-level troubleshooting programs that does nothing... Would love to hear if anyone else has found another way to fix this.
ReplyDeleteIt Works.......!!!!!!!! Thanks
ReplyDeleteThe Same Problem i was facing for long and it troubles me a lot.
thankx buddy lov from india
ReplyDeleteGreat work man.....ur awesome thanks for the fix
ReplyDeleteGod! Looking for a solution for hours!
ReplyDeleteThanks alot for the right solution!
ReplyDeleteThanks - very good well done!
ReplyDelete- Surely this is a Bug though that MS should fix?
This seems to have worked for a lot of people in the past but now with the advent of Windows 10 and Microsoft Office 2016, the same problem arises without the capability to "run compatability mode". Now Windows 10 only has "troubleshoot compatability" which is one of those useless surface-level troubleshooting programs that does nothing... Would love to hear if anyone else has found another way to fix this.
ReplyDeleteSame issue here!
ReplyDeleteThe "compatibility mode" proposal doesn't seem to be a solution any more!
If any one has a clue please to share with us.