Excel Calendar
-
Monday, May 21, 2012 12:50 PMWe have a shared excel spreadsheet that has a calendar in it that we have to select a date in. Everyone else can see the dates, I can manipulate and selected a square but I can't see the dates.
All Replies
-
Monday, May 21, 2012 2:25 PMMake sure you have the Excel Calendar Control installed.
gsnu201202
-
Monday, May 21, 2012 2:38 PMWhich version of Microsoft Office do you have? The Calendar Control was included with Office 2007 and before, but only in the editions that included Microsoft Access, so not with Office Home and Student or Office Home and Business. And the Calendar Control has been discontinued in Office 2010.
Regards, Hans Vogelaar
-
Monday, May 21, 2012 2:50 PMI have office 2007. We have the mscal.ocx file installed. It now allows me to manipulate but just can't see the dates.
-
Monday, May 21, 2012 3:13 PMWhat happens if you create a new workbook and insert the calendar control on a worksheet or on a userform in the Visual Basic Editor? Can you see the dates?
Regards, Hans Vogelaar
-
Monday, May 21, 2012 3:17 PM
Sorry, not that advanced, Someone else created it. I'm just the only one that can't see the dates.
-
Monday, May 21, 2012 3:58 PM
It's not that complicated.
- Create a new workbook.
- Activate the Developer tab of the ribbon. (See http://office.microsoft.com/en-us/excel-help/show-the-developer-tab-or-run-in-developer-mode-HA010173052.aspx if you don't see it)
- Click Insert > More Controls (the button in the lower right corner of the ActiveX section).
- Scroll down until you see Calendar Control 12.0.
- Select it, then click OK.
- Click in the worksheet.
- You should now have a calendar control.
- Click to unhighlight the Design Mode button on the ribbon.
Can you see the dates on the calendar control?
(You can discard this workbook when you're done with it)
Regards, Hans Vogelaar
-
Monday, May 21, 2012 4:41 PMI'm able to get it working on a new calendar. However, when I go into our shared, i still don't have the dates. sorry.
-
Monday, May 21, 2012 7:43 PM
Thanks for testing that - we now know that the problem is not with the calendar control itself.
Is there a conspicuous difference between your PC and that of your colleagues? Different Windows version, different Office version, other aspects?
Regards, Hans Vogelaar
- Marked As Answer by Jaynet ZhangMicrosoft Contingent Staff, Moderator Monday, May 28, 2012 2:05 AM
-
Thursday, May 24, 2012 1:49 AMModerator
Hi,
I agree with Hans, and please just check the questions of Hans, and we will try our best to help you.
And as my thought, just check if it is a font issue, go to others’ Fonts folder and copy all the fonts, then paste the fonts into your folder.
Jaynet Zhang
TechNet Community Support
-
Tuesday, May 29, 2012 11:46 AMWe all have windows xp, everyone has different models of PC's.
-
Tuesday, May 29, 2012 12:51 PM
OK, so everybody has Windows XP. Do all users have Office 2007? And which edition:
- Basic
- Home and Student
- Standard
- Small Business
- Professional (Plus)
- Ultimate
- Enterprise
Regards, Hans Vogelaar
-
Tuesday, May 29, 2012 1:27 PMmany different versions, I have office 2007 and I'm the only one with the issue.
-
Tuesday, May 29, 2012 1:27 PMWe had to add mscal.ocx to my computer to even give me the ability to use the calendar without breaking the tool in the actual spreadsheet.
-
Tuesday, May 29, 2012 2:23 PM
Has the calendar control been registered correctly? Try the following:
In Windows, select Start | Run...
Type the following, then press Enter or click OK
regsvr32 mscal.ocx
Regards, Hans Vogelaar
-
Tuesday, May 29, 2012 3:46 PMit says it failed
-
Tuesday, May 29, 2012 3:52 PMThat means that an incorrect version of mscal.ocx has been installed. Try copying mscal.ocx from a computer where it works that has the same version of Microsoft Office to your computer (from C:\Windows\System32 to C:\Windows\System32). Then try registering it again.
Regards, Hans Vogelaar
.png)
