Search the Community

As it says in the title. Word takes ages (2-5 mins) to open on some machines. Usually from files downloaded from the web. We have ESET antivirus which I have seen on the web as the cause of the problem for some people. However, when I disable it, it makes no difference. Thanks in advance!

Looking for some advice, have got a number of users who are adding additional Exchange mailboxes manually and it all works fine until they log off. When the log back in the additional mailboxes which are added manually disappear. Any help and advice would be appreciated. Running Win7 and Office 2010 SP2

Good Afternoon All, I have been made aware a very bizarre issue where after inserting an image into a Word document, keystrokes become inconsistent and strokes are missed! I have tested this and found that only Word is affected and that the user must log off and on again to remedy the issue! I have tested Word in safe mode and the behaviour still occurs! I have reinstalled Office and the behaviour still occurs. I have searched the Internet for answers and am coming up with nothing! Has anyone experienced this before? Thanks, TomHD

With the current high threat of Ransomware I'm debating whether to use a group policy object to block all macros from running. But what are the cons of doing this? What can break if I action this? Regards

Hi I have one user that has a strange issue they have put emails into folders but no emails are displaying in these folders they have been fine till recently I have checked on the Server (2008 Exchange 2010) and logged in and had a look and they are right can't see any emails in the folders Inbox etc are fine just the folders have been created have no emails in, checked a few other users and they are fine just seems one user. I have tried downloading backup PST and importing this into outlook but again all folders showing as empty. Does anyone have any ideas please.

Some useful ones I've done recently Print Preview (not through file print way) Sub PrintPreviewEditMode() ActiveDocument.PrintPreview ActiveWindow.View.Zoom = 100 End Sub Add Draft Watermark (or any other, just swap out draft for any other word) Sub InsertDraftWaterMark() Dim oSection As Section Dim oHeader As HeaderFooter Dim oRng As Range Dim oShape As Shape For Each oSection In ActiveDocument.Sections For Each oHeader In oSection.Headers If oHeader.Exists Then Set oRng = oHeader.Range oRng.End = oRng.Paragraphs(1).Range.End - 1 For Each oShape In oRng.ShapeRange If oShape.Type = 15 Then oShape.Delete Next oShape End If Next oHeader Next oSection ActiveDocument.Sections(1).Range.Select ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Selection.HeaderFooter.Shapes.AddTextEffect( _ PowerPlusWaterMarkObject, "DRAFT", "Calibri", 1, False, False, _ 0, 0).Select Selection.ShapeRange.Name = "PowerPlusWaterMarkObject" Selection.ShapeRange.TextEffect.NormalizedHeight = False Selection.ShapeRange.Line.Visible = False Selection.ShapeRange.Fill.Visible = True Selection.ShapeRange.Fill.Solid Selection.ShapeRange.Fill.ForeColor.RGB = RGB(192, 192, 192) Selection.ShapeRange.Fill.Transparency = 0.5 Selection.ShapeRange.Rotation = 315 Selection.ShapeRange.LockAspectRatio = True Selection.ShapeRange.Height = CentimetersToPoints(8.42) Selection.ShapeRange.Width = CentimetersToPoints(14.03) Selection.ShapeRange.WrapFormat.AllowOverlap = True Selection.ShapeRange.WrapFormat.Side = wdWrapNone Selection.ShapeRange.WrapFormat.Type = 3 Selection.ShapeRange.RelativeHorizontalPosition = _ wdRelativeVerticalPositionMargin Selection.ShapeRange.RelativeVerticalPosition = _ wdRelativeVerticalPositionMargin Selection.ShapeRange.Left = wdShapeCenter Selection.ShapeRange.Top = wdShapeCenter ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument End Sub Remove Watermarks Sub RemoveWaterMark() Dim oSection As Section Dim oHeader As HeaderFooter Dim oRng As Range Dim oShape As Shape For Each oSection In ActiveDocument.Sections For Each oHeader In oSection.Headers If oHeader.Exists Then Set oRng = oHeader.Range oRng.End = oRng.Paragraphs(1).Range.End - 1 For Each oShape In oRng.ShapeRange If oShape.Type = 15 Then oShape.Delete Next oShape End If Next oHeader Next oSection End Sub Just thought I'd share

Morning Everyone, I am wondering if anyone else has come across the same issue as ourselves. We installed some new PCs over summer with Windows 7 and Office 2010. We also rebuilt some existing machines with the same config. All these machines, when you select clipart in the Office apps, and choose Find more at Office.com, are getting this web page error: http://office.microsoft.com/en-gb/images/?CTT=6&ver=14&app=winword.exe. Anyone else had this and managed to solve it? By the way, I have added *.microsoft.com, microsoft.com, office.com and office.microsoft.com into the Sophos firewall but it doesn't look like a firewall issue - it looks more an MS link issue to me. Thanks A

In excel I am trying to generate an assessment sheet where if I tick (using control check boxes which I have managed) certain statements in a list it will place them one under the other on a new sheet. I can get it to put the statements when checked on a new sheet but only where the code is, I want it to automatically create the list one after the other even if the statements selected are not selected one after the other i.e. when statements 1,4,6 and 7 are ticked they appear on another sheet under each other 1,2,3,4, is this possible?

Hi all Wonder if anyone knew if it was possible to produce a countif statement that would use certain results and then fill the cell a certain colour. I know you can use a countif to count cell colours. I am basically trying to use a countif to pull through assessment data (which I have already done, it works out percentage A-C, A-G etc) and then based on the results then colour the cells that tells me if that grade is expected or beyond expected by comparing it to other data within the spreadsheet. Is this possible, any ideas / comments much appreciated. (Office 2010 and 2013 both in use - if that helps)

They are using the insert chart tool. [ATTACH=CONFIG]23536[/ATTACH] And then clicking manage templates, [ATTACH=CONFIG]23537[/ATTACH] and then because their appdata, is stored with their documents they can access all other students document. Don't know if anyone else has this problem. thanks guysss

Hi all, I have been passed over an Access database that needs some modifications. It is a relatively simple database, and most of the modifications I have done. However, I need to now dump some of the data out into a word document, which I can partially do, however I don't have all the code required. I was hoping there might be some Access gurus on here that might be able to lend a hand / point me in the right direction I am aiming to: The database stored 'bookings' and has multiple tables with lookup data that all are matched in the bookings table. Ie. Students table, Tutors table, Rooms table and subjects table. I need to present all the bookings for a particular tutor or student in a grid 'timetable' view. I have created the timetable template in Word and I have inserted bookmarks in each cell. I currently have some VBA code that will dump a particular field into a particular bookmark area The Issue: There are three parts that I need some assistance with. 1. I need to be able to select a tutor's name (from a listbox preferably) and it only give me the bookings for that tutor. I can try and pull data from a query, however as it stands i've only managed to get it to prompt me for manual input of a name rather than look at a listbox and set that name as the criteria. 2. Only IDs are stored in the bookings table, the data I want to pull out is the actual friendly names, which are stored in the seperate tables. 3. I need to input the bookings into the correct cell in the table based on the timeslot that is selected. Ie. If the booking is put against timeslot: "Monday A Session 1", then it needs to go into cell with bookmark 'mon1_session1_subjectname'. I can do a lost of if else statements, but it's how do I get all the data together to take from? The database is attached if you wish to have a look: LFC LSA_Lauren Monks.zip At the moment I have none of the above functionality set up, and a few bits are broken (work in progress), but more so that you can have a better understanding of the database. Thanks in advance for any assistance! I haven't done any Access work for a few years, and I'm a bit rusty!

Hi All, I am looking for an access developer to fix a simple stock inventory database that was created in-house a long time ago. The database itself is old and long in the tooth, so I am looking for someone to ideally have a look to see if it can be fixed and if not create a new one for us. We have a budget of around £1000 for someone to either get the existing one working or to make us a new one. Please PM me for further details.

So, I have been asked to turn a column of "age in months" into a a column with year/months format: Eg. 126 becomes 11/6 So, I have come up with this rather beautifully ugly formula: =ROUND(B3/12,0)&"/"&ROUND((MID(ROUND(B3/12,2),FIND(".",ROUND(B3/12,2),2),2))*12,0) Can anyone do it more elegantly?

Morning Everyone, We are considering moving out staff users over to the Outlook 2010 client. As we use mandatory profiles we are having problems getting the signature to stick. Apparently it will not work with mandatory profiles so after a bit of research on the internet I found this code: mklink /d C:\users\{username}\appdata\roaming\microsoft\signatures U:\My Settings\signature\ Will I need to put this in a vbs script and get it to run on logon? Can anyone help me with this? I know staff will moan if they cannot get their signatures up and running. Many thanks Gareth

All, I have been trying to reduce unneeded internet traffic at our site of late, due to poor speeds on the connection I noted a lot of traffic to Office online help – specifically officeimg.vo.msecnd.net Doing a bit of digging and it seems office 2010 and 2013 connect to this address automatically at startup and download stuff. At our site it was roughly 1 – 1.5 Gig a day! Changing the Office 2010 registry key HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common\Internet\UseOnlineContent Or Office 2013 HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet\UseOnlineContent To REG_DWORD value 0 Disables this and frees up that bit more bandwith I’ve pushed this out via Group Policy preferences, but you could just as easily use a login script or modify mandatory profiles. Hope this is helpful

Hi all, I have a list of date and times (in one column), the data showing is just dd/mm/yyyy hh:mm but the data for the seconds is also present and if I change the format I can see it. What I would like is to create a list of the unique records but only down to the minute data. Unfortunately if I use the filter option to copy unique records I get a list of dates and times that are unique down to the second. Here's a sample of the data; 05/09/2013 13:02:03 05/09/2013 14:02:53 05/09/2013 14:02:55 05/09/2013 14:02:58 05/09/2013 14:03:00 05/09/2013 14:03:02 05/09/2013 14:03:04 05/09/2013 14:03:06 05/09/2013 14:03:08 05/09/2013 13:02:05 05/09/2013 13:30:40 05/09/2013 14:02:33 05/09/2013 13:01:01 05/09/2013 14:02:54 05/09/2013 14:03:07 05/09/2013 14:02:37 05/09/2013 14:02:58 05/09/2013 14:03:03 05/09/2013 14:02:41 So the output I'd need would just be 5 records of 05/09/2013 13:01 05/09/2013 13:02 05/09/2013 13:30 05/09/2013 14:02 05/09/2013 14:03 (and preferably in chronological order) I have a lot of these to sort on a huge scale so a formula solution would be better, I've tried using =Left but that uses the raw data (e.g. 41522.5430902778 for 13:02:03) and I don't know how/if I can convert that back to the format I need. So any help greatly appreciated. Thanks

We have an issue here with storing archive files from outlook. As it stands, we store them on the user's home directory. This is fine for the majority of people. For example, my archives have worked perfectly for a good 7 years without any issues. However, some users forever have issues with the files corrupting. One of those users is the Head Teacher. One of his archive files has suddenly gone from 3GB+ to 20MB in size. And as he has taken a while to notice it isn't working properly, I am struggling to find a working copy of the file, as it was created fresh not too long ago. How do other schools who use external Exchange servers with Outlook handle this?

Word and Excel randomly close when working and nothing is reported in the logs. Have repaired Office and made sure its all up to date, any ideas?

Hi, all.. for those that are interested, here's my script to deploy office at startup ' Office 2010 Deployment script dim Office2010 Dim WSHShell Set WSHShell = WScript.CreateObject("WScript.Shell") Dim wshnetwork Set WshNetwork = CreateObject("WScript.Network") wshshell.Popup "Looking for Office 2010 on this system...",2,"ICT Support" on error resume next Office2010 = wshshell.regread("HKLM\SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName\Office2010") if not Office2010 = "YES" then wshshell.Popup "Office 2010 is not yet installed on this computer. Installation of Microsoft Office 2010 will start in a moment. This will take around 30 minutes... Grab a cuppa!",5,"ICT Support" WshShell.Run "\\apps\apps$\Office2010\Setup.exe /config \\apps\apps$\Office2010\ProPlus.WW\config.xml",10,True 'set flag so the installation doesn't start again at next reboot wshshell.regwrite "HKLM\SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName\Office2010", "YES", "REG_SZ" 'restart the machine ' wait 2700 secs (45 mins) before auto OK fo message to allow ICT admins to see when a room has been completed during summer! wshshell.Popup "Microsoft Office 2010 Installation Complete!",2700,"ICT Support" WshShell.Run "c:\windows\system32\shutdown.exe -r -t 0" else wshshell.Popup "Good Stuff, Office is already installed on this machine.",2,"ICT Support" End If

So, how do you go about deploying Office 2010? Put into the OS Image and deploy or is there a nice way similar to that of GPSI? Or can you get GPSI working?

Many folks on here testing Office 2010? Ive got a database that uses the mscal.ocx function present in 2003/2007. It isnt present in 2010 and according to this: Changes in Access 2010 it says to use "An alternative is to use the date picker control in Access 2010" Anyone know if tihs Date Picker Control is available in 2007 as well? This is a multi user access file so Im gonna have to go back to 2007 if this isnt compatible with both 2010 and 2007

Hi, I am just about to download the Office 2010 Group Policy templates here: Download details: Office 2010 Administrative Template files (ADM, ADMX/ADML) and Office Customization Tool There is a 32 and 64 bit to download. Is that for 32 & 64 bit office or for the server os? Thanks

Hi All, We have done a small pilot of Office 2010 at an outcentre, installing it on all the staff PC's but not the IT suites or Classrooms. We are having some major issues however with the staff that roam between machines with the different versions on, this affects quite a few people as we have teachers who work at multiple sites. Setup Info: Staff Use Roaming Profiles All Computers are Win XP Office Versions are Professional 2003 and 2010 Exchange Server is 2003 So far we have Staff member with outlook working on 2003 logs on to a 2010 machine outlook works. When they go back to a machines with 2003 installed they then get the message unable to open your default e-mail folders; your profile is not configured The outlook profile is there, but from mail in control panel you are unable to edit it and the users name does not show up in the box below server name. So far all we can do to get working in 2003 is either a new outlook profile or delete and re-create. However the problem comes back as soon as they log on/off a machines with outlook 2010. Any help you can give would be great as this is currently dring about 30 people mad and we need to resolve this before the first full phase of rollout can take place. Unfortunately with 1200 machinhes we need to phase the rollout over a few months to get staff trained up etc.

At one of the primary schools I support the e-mail settings are picking up countys e-mail server, where as we now have an internal exchange. How do I go about getting outlook to pick up the new server settings automatically without having to go around every user? is it in a group policy somewhere? Using outlook 2010 and exchange 2003

Not sure how to describe what i am trying to do, but i will try. The Bursar is trying to let go of Lotus notes as he is the only person not using Office in the school. One thing he can do is he can make a word processing document in lotus, and have like a text box almost, but it looks just like a normal line of text and it might say and when you click on of the text it dissappears and allows you to type your name in that area. I am sure i have seen this done in Word, how do i do it in Word 2010?