![]() ![]() To illustrate the problem, please have a look at the source data formats in an Excel worksheet: As a result, in a Word document, the data appears in the format in which it is stored internally in Excel, and not in the format applied to cells. The problems typically occur with numbers formatted as percentage or currency, or numbers containing leading zeros such as zip codes.Ĭause: By default, Microsoft Word uses the OLE DB connection, which pulls in the information but not formats. If a matching filename in a matching folder clashes, the local one is shown and the workgroup one is not available.When performing a mail merge from an Excel worksheet, some of your numeric data may lose formatting after coming through the merge. ![]() ![]() If you have a folder of the same name on local and workgroup templates, the contents are shown for both on the same tab. Subfolders of subfolders appear as a tab, exactly as if they were direct 'child' folders of templates folder. Note3: just in case you did not already know, sub-folders of your local and your workgroup folders are presented as tabs, so you can organise you templates by department, for example. ![]() Note2: you can also set a policy to take you straight to this "Office 2003" style file > new dialogue without all the other gallery stuff, if you prefer. Note: this can also be set by group policy for everyone to point to the same place, this makes sharing templates with colleagues really easy (this is where you would change the local one if you want to, but seriously, don't do that) To change the workgroup location go to Office button > Word Options > Advanced > (scroll down) > File locations button > provide a path in the workgroup templates setting in the dialogue box. %userprofile%\AppData\Roaming\Microsoft\Templates You can change it but I would recommend leaving it alone. Your local templates location depends on the version of windows you are running, so if you tell us that I can tell you where to look locally. This can be your personal templates folder stored in your profile, or a shared workgroup location. You need your templates to be in the right place in the first place to use the file > new method. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |