Active questions tagged microsoft-office-2016 - Super User most recent 30 from superuser.com 2019-01-22T02:41:55Z http://asianhospital.com/?id=feeds/tag?tagnames=microsoft-office-2016 http://www.creativecommons.org/licenses/by-sa/3.0/rdf http://asianhospital.com/?id=q/1258482 0 How to remove proofing language from being used in Microsoft Word Dominique http://asianhospital.com/?id=users/547147 2017-10-12T10:12:37Z 2019-01-16T06:01:20Z <p>This is a really bugging one: I am writing a document in Dutch language, and from the moment I start typing, the proofing language changes into English, mentioning that I am writing nothing but errors.</p> <p>As mentioned on <a href="https://support.office.com/en-us/article/Check-spelling-and-grammar-in-a-different-language-667ba67a-a202-42fd-8596-edc1fa320e00" rel="nofollow noreferrer">Office support</a>, I have set the proofing language as "Dutch (Belgium)", but this does not solve my issue. In the Language preference, I have removed "English (Belgium)" from the list (English is not a Belgian language, so how can you have an "English (Belgium)" proofing), but after having restarted MS Word, the "English (Belgium)" just reappears in the Language preference and when starting typing, the proofing language changes immediately to "English (Belgium)".</p> <p>Sorry for sounding so frustrated (but I really am), does anybody know how I can get rid of a proofing language so that it never appears again? (I've just checked "Add and Remove Programs" and I don't find any language references)</p> <p>I'm working with Microsoft Word 2016 MSO 32-bit.</p> http://asianhospital.com/?id=q/1393005 -1 How to stop Excel 2016 from tracking cells formats or content? [closed] Marlene http://asianhospital.com/?id=users/983683 2019-01-11T02:58:49Z 2019-01-11T02:58:49Z <p>I use excel 2016 as was possible in the early days when it was a great self-programming and thought tool. I build my own formulas, used them in my chosen content, and do not expect excel to try to generalize about my future needs. I do not want it to check my work. I do not want to be interrupted when it gets confused, and be denied access to my document while Excel runs through a script. I do not want to have to manually save every other second to avoid nosy excel. I found that if I do not watch my screen closely enough, I miss cases where excel autocorrects or force-ignores my intention. </p> http://asianhospital.com/?id=q/1280203 0 Disable Office "UPDATES AVAILABLE" notification akinuri http://asianhospital.com/?id=users/256296 2017-12-26T17:33:34Z 2019-01-08T16:48:48Z <p>I'm using Office Pro Plus 2016 on Windows 10 Pro 64-bit and having an annoying problem.</p> <p>I have turned off Windows Update and Office Updates. This is working fine, I think. But I'm getting this annoying notification in Office:</p> <blockquote> <p>UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps.</p> </blockquote> <p>Coming accross to this notification every time I launch an Office product is starting to get to me. Isn't there a way to get rid of this?</p> <p><a href="https://i.stack.imgur.com/o5Sg2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o5Sg2.png" alt="The annoying UPDATES AVAILABLE notification"></a></p> <hr> <p>Turned Windows Update off using the methods described in <a href="http://www.thewindowsclub.com/turn-off-windows-update-in-windows-10" rel="nofollow noreferrer">How to turn off Windows Update in Windows 10</a>.</p> <hr> <p><a href="https://i.stack.imgur.com/1ZEaj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1ZEaj.png" alt="Registry screenshot"></a></p> http://asianhospital.com/?id=q/1391355 0 Is there a way to export a MS Access query or report without showing duplicated cells? Kureno http://asianhospital.com/?id=users/429025 2019-01-07T05:47:41Z 2019-01-07T06:52:31Z <p>I'm working on a MS Access 2016 database that contains information about a collection of recipe books. I have a few tables for different types of data that are linked to each other using many-to-one and many-to-many relationships. Then, I want to export a "table of results" (in Excel format) for each book (via a query), containing a list of recipe names, page, ingredients, "companion" ingredients, utensils and notes. The output should be something like this:</p> <p><a href="https://i.stack.imgur.com/YXIOC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YXIOC.jpg" alt="Desired result"></a></p> <p>I've tried to do this through the report tool in Access and setting the "Hide replicates" control to "Yes". The problem is that when I generate the report, the data keeps repeating itself, like this:</p> <p><a href="https://i.stack.imgur.com/UkeBw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UkeBw.jpg" alt="Attained result"></a></p> <p>My question is if there's a way to do what I want, or something similar, without modifying each table one by one, because I have more than 70 books and 7000+ recipes. My query subschema is there:</p> <p><a href="https://i.stack.imgur.com/1o5Ly.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1o5Ly.jpg" alt="DB query schema"></a></p> <p>And the generated SQL:</p> <pre><code>SELECT N_recetas.no_libro, N_recetas.Id, N_recetas.nombre_receta, N_recetas.pag, N_ingredientes.ingrediente, N_acompanamientos.nombre_acomp, N_utensilios.utensilio, N_recetas.notas FROM N_utensilios RIGHT JOIN ((((N_libros INNER JOIN N_recetas ON N_libros.no_libro = N_recetas.no_libro) LEFT JOIN (N_acompanamientos RIGHT JOIN rels_rec_acomp ON N_acompanamientos.Id = rels_rec_acomp.Id_acompanamiento_Fk) ON N_recetas.Id = rels_rec_acomp.Id_receta_FK) LEFT JOIN rels_rec_utensilios ON N_recetas.Id = rels_rec_utensilios.IdRecetaFK) INNER JOIN (N_ingredientes INNER JOIN rels_rec_ings ON N_ingredientes.id_ingrediente = rels_rec_ings.Id_ingrediente_FK) ON N_recetas.Id = rels_rec_ings.Id_receta_FK) ON N_utensilios.Id = rels_rec_utensilios.IdUtensilioFK WHERE (((N_recetas.no_libro)=78)); </code></pre> http://asianhospital.com/?id=q/979691 0 PDFMOutlookAddin.dll not compatible with Outlook 2016 Jen Scott http://asianhospital.com/?id=users/470227 2015-09-29T14:00:13Z 2018-12-23T18:02:35Z <p>Adobe has informed me that the reason I can no longer print PDF Portfolios from email is that they have not yet patched their PDF plug-in (PDFMOutlookAddin.dll) to work with Outlook 2016, despite the fact that Office 2016 is now the only download option from Office 365. </p> <p>I use Acrobat Standard XI. Adobe told however that they have no timetable for making XI or DC compatible.</p> <p>Does anyone know if it's possible to brute force patch my own PDFMaker driver plug-in? Or is there a secret nightly release candidate community that might be willing to share?</p> http://asianhospital.com/?id=q/980035 7 Word hyphenation feature is not available FiveO http://asianhospital.com/?id=users/161601 2015-09-30T07:47:04Z 2018-12-22T11:01:30Z <p>When opening a Document in Word 2016, I always get the following error message </p> <blockquote> <p>Word hyphenation feature is not available. Run the Microsoft Office Setup program, install this feature an then try again</p> </blockquote> <p><a href="https://i.stack.imgur.com/kGWey.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/kGWey.jpg" alt="enter image description here"></a></p> <p>But there is no such option to add the feature in the Office 2016 Setup? </p> <p><strong>How can I add this feature to Word in Office 2016?</strong></p> http://asianhospital.com/?id=q/1385397 0 Mac Excel - VBA written in Japanese gets corrupted Noir Antares http://asianhospital.com/?id=users/974951 2018-12-18T00:51:35Z 2018-12-18T00:51:35Z <p>I have an excel file with a password-protected VBA macro written with Japanese characters that I'm having quite the trouble of working with.</p> <p>Whenever I tried opening it on Excel 2016 for Mac OS X, the file gives me several error pop ups and when I go to view the macro, the password protection is gone and when can view the VBA code, it is filled with mojibake text for all the Japanese characters.</p> <p>I've run this same file with a Windows PC before and it works smoothly, so I'm thinking this is a Mac Office-specific issue. </p> <p>Is there anyway to fix this on Mac Excel?</p> http://asianhospital.com/?id=q/1089618 6 How to disable Outlook 2016 search history? guest http://asianhospital.com/?id=users/606552 2016-06-15T14:21:29Z 2018-12-13T11:00:50Z <p>I just updated to Office 2016. I'm not a fan of the recent search dropdown list when you click on the search box in Outlook (refer to image posted below). Does anyone know how to disable this? </p> <p><a href="https://i.stack.imgur.com/R0ej6.png" rel="noreferrer"><img src="https://i.stack.imgur.com/R0ej6.png" alt="enter image description here"></a></p> http://asianhospital.com/?id=q/1002843 0 Making small caps in Word 2016 for Mac Sarah http://asianhospital.com/?id=users/524015 2015-11-19T16:51:33Z 2018-12-13T09:01:05Z <p>How do I make small caps in Microsoft Word 2016 for Mac? The keyboard shortcut isn't working and the option no longer appears on the tool bar</p> http://asianhospital.com/?id=q/1381821 1 How do you change Word 2016's Display language? user428697 http://asianhospital.com/?id=users/428697 2018-12-08T03:40:42Z 2018-12-08T04:03:37Z <p>(Note that I am referring to the <strong>Display</strong> language, <em>not</em> the keyboard.)</p> <p>I have configured the default language in a Windows 10 Pro user profile to Spanish (Mexico). It's working fine. All Start menu text is in Spanish and even Chrome displays everything in Spanish.</p> <p>But when I run Word 2016 all of its menus are in English. In Word Options > Language the editing language is set to default to Spanish (Mexico). Under "Choose Display and Help Languages" the default is "Match Microsoft Windows," which suggests to me that all Word menus should be in Spanish, just like Chrome and Windows are doing. A second, greyed out choice is English.</p> <p>The very last sentence on this Options page is says, "View display languages installed for each Microsoft Office program. Click on it and a table appears. Word and Outlook are listed. Under the "Office Display Language" is English for both. Nothing appears in the "Other Display Languages". I see no option to add another display language.</p> <p>Earlier versions of Office had downloadable Language packs but I can't find one for Office 2016, not even in the volume license downloads.</p> <p>I've tried this on two W10Pro Ofc2016 computers and get the same results in both. What step or trick am I missing?</p> http://asianhospital.com/?id=q/1358965 0 Microsoft Word/Excel equivalent to the "Search the Menus" functionality of Google Docs/Sheets Anonymous http://asianhospital.com/?id=users/815933 2018-09-17T18:51:38Z 2018-12-07T00:43:13Z <p>In Google Docs/Sheets, I can hit <code>Alt-/</code> (<code>M-/</code> for Emacs users :) ) to bring up a menu that allows me to quickly search all the menus for a particular function and to select that function with <code>[Enter]</code> (e.g. bold, create bulleted list, change font size). This is particularly helpful because it allows me to continue typing without switching to the mouse. Is there an equivalent function within Microsoft Office 2016/Word/Excel?</p> http://asianhospital.com/?id=q/1380984 0 MS Office 2016 file operation screens: setting the width of the leftmost column (that keeps a list of recent files) Christian Geiselmann http://asianhospital.com/?id=users/541544 2018-12-05T11:48:13Z 2018-12-05T12:50:15Z <p>At my workplace I am forced to use MS Office 2016. With this - as compared to Office 2010 - comes the following problem: </p> <p>Word 2016 (and the other Office 2016 applications) looks in various situations like this: </p> <p><a href="https://i.stack.imgur.com/YzkHQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YzkHQ.jpg" alt="enter image description here"></a></p> <p>(This is when you chose to do certain file operations such as saving, opening or creating a file.)</p> <p>Pay attention to the left column (blue). This column can conventiently display a list of recently used documents. </p> <p>However, most unconventiently, the column is too narrow to display file names of any meaningful length. (It is almost as if this was designed by someone still living in a DOS world where filenames cannot be longer than eight characters. Ridiculous, really.) File names cut in half - as visible in my screenshot - are of absolutely no use, especially when you are working with multiple files with systematic names. </p> <p><strong>My question:</strong> Is there a way to make this left column wider? </p> <p>I am pretty sure there is no regular way to do this. But perhaps there is a registry setting that does the trick?</p> <p>Note: I am asking here for MS Word, but the same problem torments me in the other Office applications. </p> <p>Note also: In the so called "start screen" Microsoft has managed do adjust the left column to the necessary width. (But this appears only on proper start of the application, not during regular work.)</p> <p><a href="https://i.stack.imgur.com/27Py9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/27Py9.jpg" alt="enter image description here"></a></p> http://asianhospital.com/?id=q/1156436 1 Windows 10 search shows office 2013 apps after upgrade to 2016 Digi http://asianhospital.com/?id=users/675073 2016-12-14T13:04:51Z 2018-12-04T18:28:01Z <p>I've Googled as much as I could but I cannot seem to find a solution to this problem.</p> <p>I've got a Windows 10 Pro system that had an activated (legal) copy of Office 2013 installed. I've used Office 2013. Last week I upgraded to Office 2016 and reactivated that.</p> <p>I usually start my programs by hitting the Windows key and searching for programs. However if I search for Word or Excel from the start menu it's showing the 2013 edition of the apps that aren't installed anymore. It's not doing anything either when I click on it. </p> <p>Office 2016 apps are showing up in the all apps section of the start menu, but not on searching for it.</p> <p>I've rebuild my search indexes. I've searched (with Search Everything) for filesnames that resemble word or excel 2013, I'm finding nothing.</p> <p>How to get rid of those references?</p> http://asianhospital.com/?id=q/1354472 1 How to disable/enable office clipboard IGRACH http://asianhospital.com/?id=users/275486 2018-09-01T20:54:22Z 2018-11-28T17:38:22Z <p><strong>Question:</strong> Is there any way that you can disable clipboard in Office 2016? </p> <p>I don't mean show/hide status when coping or similar stuff from clipboard options. I mean to completely turn it off. It so intrusive that you cant turn it off from the application itself. Also it's a privacy concern because everything that you copy on your device goes there if any application (Excel, Word, etc.) is open. If they are all closed it will copy system clipboard to Office clipboard when you start Word/Excel. </p> <p>I'm looking for any kind of solution (3rd party, registry, etc...). I have Win 7/64 bit and Office 2016/64 bit. </p> http://asianhospital.com/?id=q/1378661 0 Office 2016 blocks document permanently after PC crashed Jackie_de http://asianhospital.com/?id=users/424865 2018-11-27T06:48:39Z 2018-11-27T09:33:45Z <p>I have recently upgraded from Office 2007 to Office 2016, and ever since then I observe the following behaviour: </p> <p>I open a document from my Synology DS216J NAS mounted as UNC-Path via SMB for example in Excel for modification. The PC crashes for some reason, and needs to be rebooted without the possibility of closing Excel in advance. After the reboot, I try to open the document again. However, Excel displays a dialog telling that the document is currently in use. In Windows explorer, on that moutned drive, I see the original Office-document (test1.xlsx), and a hidden file (~$test1.xlsx), which both cannot be deleted in Windows explorer. </p> <p>The strange thing is: I cannot delete these two files even if all office processes are closed. Even if I shutdown this PC, start another PC in the same network, these two files are blocked and not deletable.</p> <p>My current workaround is to access my NAS logging in to the NAS directly and deleting the files from there, which works. Another thing I noticed that deleting the ~?-file is not suficient, I need to delete both files, before make a copy of the original file and rename after deletion.</p> <p>My question is simple: who is blocking that file after a PC has crashed, even if Windows is restarted, or the file is being accessed from another PC, with the previously locking PC not even running? Is this a new Office feature (using NTFS alternate datastream or something similar)? Or is it a problem of my NAS' SMB implementation?</p> <p>Finally, what is the suggested way to deal with that kind of deadlock-situation?</p> http://asianhospital.com/?id=q/1372120 1 How to expand all sections at once in OneNote's document? mrJoe http://asianhospital.com/?id=users/668280 2018-11-02T09:17:07Z 2018-11-22T20:23:30Z <p>I got a <code>.one</code> document containing a lot of sections and subsections. I want to convert this document to <code>.pdf</code> or other commonly supported file that I could view on my mobile phone. Unfortunately, OneNote's export option allows me to export only these sections that I manually opened by double clicking on them. And as you can see on the picture below, all subsections are collapsed by default. </p> <p><a href="https://i.stack.imgur.com/FW8e0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FW8e0.png" alt="Click to open the photo"></a></p> <p>The question is how I can expand all of the subsections at once, so I could export the document to another file format with all the subsections being visible. </p> http://asianhospital.com/?id=q/1029891 1 How to fix scrolling lag in office 2016 windows 10 BugShotGG http://asianhospital.com/?id=users/125986 2016-01-22T11:50:20Z 2018-11-19T14:25:42Z <p>I notice a weird lag while scrolling in some word documents. It takes almost 2 sec for the word to react on scrolling and when it does it goes line by line. Same thing when I actually click on the scrolling bar of the document. Usually happens when I open 2 documents or more. Is there a way to temporary fix it? I cannot wait for Microsoft to release an update.</p> http://asianhospital.com/?id=q/1374611 0 CardDAV and CalDAV for Office 2016 [closed] IMTheNachoMan http://asianhospital.com/?id=users/456058 2018-11-12T03:36:25Z 2018-11-12T11:05:15Z <p>I saw a related question but it was from 2016. I am wondering what the best CardDAV and CalDAV sync/clients there are for Office 2016.</p> http://asianhospital.com/?id=q/1373009 2 Office 2016 Pro Plus x64 bit - Save as issue Jonas http://asianhospital.com/?id=users/960898 2018-11-06T01:27:50Z 2018-11-06T01:31:48Z <p>Office 2016 Pro Plus x64 bit version no. 16.0.4266.1001</p> <p><strong>Steps to reproduce issue:</strong></p> <ol> <li>From word, powerpoint, excel or any office app, click file > save as</li> <li>Click any recently saved location (under current folder / today / this week), and it will open “save as dialog box” with C:\users\username\documents</li> </ol> <p><strong>Example:</strong> when I choose c:\users\username\documents\work under recent saved location, it opens c:\users\username\documents</p> <p><strong>Troubleshooting done:</strong></p> <ol> <li>Install office updates</li> <li>Repair office 2016</li> <li>Restart laptop</li> <li>Tried changing default save location, but office apps still opens "save as dialog box” with C:\users\username\documents whenever you click on any recent saved locations</li> </ol> http://asianhospital.com/?id=q/1342610 0 Word (2016 or 365) can't edit embedded Visio objects, with Visio 2016 installed RLH http://asianhospital.com/?id=users/91608 2018-07-23T15:20:20Z 2018-10-09T22:58:15Z <p>I just started working for a new employer that makes heavy use of Visio. I need to manage some existing documents, and one change that's been requested of me is that I make some minor changes to an embedded Visio object on the document.</p> <p>When I double click on the object, I get an error message that states</p> <blockquote> <p>The server application, source file, or item cannot be found.</p> <p>Make sure the application is properly installed, and that it has not been deleted, moved, renamed, or blocked by policy.</p> </blockquote> <p>Regarding environment, I'm using 64-bit Windows 10 Pro and all of these install attempts are with 64-bit versions. Originally, I had Office 2016 Pro installed, as well as Visio 2016. I first installed Office, then Visio. These were separate installs and from my experience, I haven't found an integrated Office installation with Word/Excel/Access/etc. <em>and</em> Visio. </p> <p>After multiple attempts with Office 2016/Visio 2016 failed and attempting after repairing both installs, I uninstalled both, installed Office 365 (downloaded from portal.office.com) and then re-installed Visio 2016. Again, this failed, even after repairing both installs.</p> <p>To be clear, the object is certainly a Visio embedded object. My co-worker can double-click on these objects on his machine and modify them within Word. If he right-clicks on the object, he can see details stating it's a Visio object. When I right-click on the object, I see an "Unknown object..." menu option.</p> <p>What might I be doing wrong in setting up Office with Visio?</p> <p>FYI, I was given access to Office 365, and I also have an MSDN account. I can install Office 2016 or use the Office 365 install-- my employer doesn't have a preference, so long as I can do my job and change embedded Visio objects within Office documents. Any clue what's going on and how to fix it, or how to further diagnose the problem?</p> <p><strong>UPDATE</strong></p> <p>Here are the current version details for these installed applications.</p> <p><strong>Word 2016</strong>: Microsoft Office 365 ProPlus, version 1807 (Build 10325.20082 Click-to-Run)</p> <p><strong>Visio 2016</strong>: Microsoft Visio Professional 2016, version 1807 (Build 10325.20082 Click-to-Run)</p> http://asianhospital.com/?id=q/1109937 5 How can I remove a Theme from One Shape of Many in Visio 2016 Eric Hepperle - CodeSlayer2010 http://asianhospital.com/?id=users/340050 2016-08-04T20:40:48Z 2018-10-04T16:30:53Z <h2>The Issue</h2> <p>I have a <strong>Visio 2016</strong> diagram that has a theme, but I want to remove the theme from one object. In Visio 2010 you could do Format > Remove Theme. I'm not seeing any such option in Vision 2016.</p> <h2>My System</h2> <ul> <li>Visio 2016 Pro</li> <li>Developer Mode enabled</li> <li>Windows 10</li> </ul> <p>Any help is appreciated</p> http://asianhospital.com/?id=q/1220764 1 Change formatting of specific numbered list item in MS Word FarhadGh http://asianhospital.com/?id=users/475658 2017-06-19T14:15:43Z 2018-09-29T20:22:36Z <p>In a numbered list in MS Word, how can I customize style just for one number? Like this:</p> <ol> <li>List item</li> <li>List item &lt;= other color, other size</li> <li>List item</li> <li>List item</li> </ol> <p>Note: What I do not mean, is changing style for text. I want customize style for menu number, itself.</p> http://asianhospital.com/?id=q/1210778 2 How to fix continuous cleanups in OneNote WoJ http://asianhospital.com/?id=users/60006 2017-05-19T10:45:53Z 2018-09-27T18:21:35Z <p>When I open a new note (<kbd>Win+N</kbd> or via the launcher) I get the message </p> <blockquote> <p>We're sorry. OneNote is cleaning up from the last time it was open. Please wait.</p> </blockquote> <p>After a while a new note is opened. This happens at every new note.</p> <p>I found a workaround: to delete the contents of <code>C:\users\%userprofile%\appdata\local\temp</code>. This fixes the issue <strong>once</strong>, that is at the next new note I have the error message again (and, again, the new note finally opens).</p> <p>These operations are perfectly replicable (new note, error, clean Temp, new note starts ok, next new note has the error, clean up ... )</p> <p><strong>Is there a proper fix for this issue?</strong> I have the latest patches and the issue is present on the net for quite a long time already (at least since early 2015).</p> http://asianhospital.com/?id=q/1355846 0 How to change the Personal/Shared/Custom Template heading in File, New in Word, Excel and other office applications Tiago Duarte http://asianhospital.com/?id=users/303492 2018-09-06T14:09:45Z 2018-09-24T12:52:29Z <p>Word (Office) allows us to configure a templates location.</p> <p>We can configure it in 3 ways:</p> <ol> <li>Personal folder set, Shared folder unset ("Personal" heading)</li> <li>Shared folder set, Personal folder unset ("Shared" heading)</li> <li>Both folders set ("Custom" heading)</li> </ol> <p>Unfortunately, none of this headings are meaningful to us and we would like to have our own heading in there.</p> <p><a href="https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_other/word-2013-templates-featured-vs-personal-vs-shared/80fffecb-74b6-4cf9-8c86-6955186ef39d" rel="nofollow noreferrer">Early research</a> tells me this isn't possible, but I though I posted anyway in hopes that someone has a nifty way of doing it :-)</p> <p><a href="https://i.stack.imgur.com/N7L8v.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N7L8v.png" alt="enter image description here"></a></p> <p>edit: currently researching spotlight providers</p> <p><a href="https://stackoverflow.com/questions/31927168/adding-a-custom-template-group-in-word-2013">https://stackoverflow.com/questions/31927168/adding-a-custom-template-group-in-word-2013</a></p> http://asianhospital.com/?id=q/1192797 0 Access 2016 - Command Button Wizard will not appear roberto tomás http://asianhospital.com/?id=users/179409 2017-03-27T14:35:45Z 2018-09-10T04:21:02Z <p>I am on windows 10 with office 2016. I am following along with <a href="http://www.gcflearnfree.org/access2013/17" rel="nofollow noreferrer">this tutorial</a> and running into an issue.</p> <p>The text describes the third step of the method as placing the button from <em>Form Layout View</em> (step 1). There is no <em>form layout view</em>, there are <em>form view</em> and <em>layout view</em>. <em>form view</em> has no design tab, so we can't place a button. That leads me to think "it must be layout view".</p> <p>When you place the button, step 4 says the <strong>Command Button Wizard</strong> will appear. It does not appear. Looking at the dropdown for the options for the controls on the right, I see <em>Use Control Wizards</em> is selected (it is darkened). The button places just fine, but no dialog appears.</p> <p>This led me to believe that maybe a different view is appropriate. There are only 3 views listed and I've already explored 2. So I looked at <em>Design View</em> next. It also shows the <em>use control wizards</em> option as selected, but placing the button does not produce the wizard.</p> <p>I went on to read about how to set up a button without the wizard. It says that you can change the values of the properties: <a href="https://support.office.com/en-us/article/Use-a-command-button-to-start-an-action-or-a-series-of-actions-c7bf2827-2f3e-42b8-83d6-6c4f0de78990#bmfromscratch" rel="nofollow noreferrer">https://support.office.com/en-us/article/Use-a-command-button-to-start-an-action-or-a-series-of-actions-c7bf2827-2f3e-42b8-83d6-6c4f0de78990#bmfromscratch</a> (see step 7)</p> <p>However, in my experience, the properties are listed (on the right), but not their values. double clicking or otherwise trying to set a value for a field, for example Name, does not work. Is there a some setup we need to do with a database before these things work properly?</p> <p><strong><em>edit</strong> - I found a part of my problem, the property sheet on the right was too narrow to show the values. dragging it out I see the key-value pairs for each property of the object I am inspecting on the form. I still don't know how to use this to set up a new record, but, at least I am getting somewhere.</em></p> <p>Finally, I started to build event, hoping I could do it that way. That brings up VisualBasic. The left panel there has properties for the button, both the property keys and their values. It is editable (!!).</p> <p>This is where I get confused. What should I do to make a new record? I don't see how to do this using properties, I'm not sure how the wizard works for this action.</p> <p>If I write the VB code like:</p> <pre><code>Option Compare Database Private Sub New_Record_Click() DoCmd.RunSQL "INSERT INTO [Order items] ([Order ID], [Menu Item ID], [Quantity ID]) VALUES (Me.Text43.Value, Me.Combo16.Value, Me.Quantity.Value)" End Sub </code></pre> <p>It appears to do nothing when I click that button in form view: I don't see the a new record when I change some fields and do this.</p> <p><em>• <strong>edit</strong>: I found that somehow I had <code>New_Record_Click</code>, probably from an earlier attempt at the button, and that was the reason. from there I was able to debug the script. It still prompts that you are about the add a row, though (probably a good thing really). This produces a solution but does not debug the wizard. I could still use help. Here's the working code:</em></p> <pre><code>Private Sub NewRecord_Click() DoCmd.RunSQL "INSERT INTO [Order items] ([Order ID], [Menu Item ID], [Quantity]) VALUES (" &amp; Me.Text43.Value &amp; ", " &amp; Me.Combo16.Value &amp; ", " &amp; Me.Quantity.Value &amp; ")" End Sub </code></pre> http://asianhospital.com/?id=q/1247906 0 Prevent copy & pasted Excel chart from updating automatically Haris http://asianhospital.com/?id=users/173599 2017-09-06T13:58:54Z 2018-09-10T00:15:21Z <p>Using a slicer in Excel, I am cycling through various categories and copy-pasting charts to a PowerPoint presentation. Unfortunately as soon as I switch the category, the copy-pasted chart updates in PowerPoint. </p> <p>I was able to overcome this issue previously by using a virtual machine and running Excel in said virtual machine. If copy &amp; pasted that way, the charts in PowerPoint wouldn't automatically update subsequently. However I don't have access to this particular workaround anymore. The update properties for linked data files in PowerPoint are set to manual and update automatically is unchecked.</p> <p>Pasting as an image is not an option because there is always a chance that someone who is looking at that presentation might want to make some last-minute changes to the chart. (i.e. Changing the wording of chart titles or something like that)</p> http://asianhospital.com/?id=q/1355248 0 Office 2016 does not activate juergen d http://asianhospital.com/?id=users/117031 2018-09-04T19:34:53Z 2018-09-07T01:35:20Z <p>I just bought Office 2016 Standard edition. I installed it, ran Windows Update to get the latest patches and now I want to activate Office.</p> <p>In the activation dialog I can either login to an account having a license or enter the product key.</p> <p>I enter the product key, Office accepts it but the next time I start Office it asks me again for the key. But I did not get any error entering the key.</p> <p>What can I do now?</p> http://asianhospital.com/?id=q/1353277 0 Any way to see Powerpoint 2016 slide timings in presenter view? Zoey Boles http://asianhospital.com/?id=users/591814 2018-08-29T04:00:02Z 2018-08-29T04:00:02Z <p>I swear, last time I used Powerpoint, there was a way to see your timings in presenter view. Or at least a progressive time bar that gave you a visual idea of where you were in your presentation.</p> <p>I'm giving a presentation with 65 slides, which needs to be done in 50 minutes. Some of the slides contain videos that last anywhere from 30 seconds to 5 minutes.</p> <p>Short of hand-calculating elapsed times to put into my notes, is there any good way to get a "faster/slower" idea of elapsed time?</p> <p>I used the rehearsal feature to see how long each slide should take, give or take, but I don't want slides auto advancing if I can avoid it. If the audience is busy laughing or whatever, I don't want to have to trample them to keep up with the train.</p> <p>I've seen similar questions on a search, but they're all pretty old or involve creating macros and copy-pasting objects across my slideshow. I'd rather avoid that mess if I could.</p> <p>I might break down and just put the timings in the notes, and/or make the slides auto-advance with "worst case" timing, but...</p> <p>...geez, I wish I knew where I was getting this memory of a timer bar in the interface. The memory is cool; it used slide timings to basically show you two bars: One was total elapsed time, and the other one was a +/- graph that would let you know how ahead or behind you were in the presentation based on elapsed time and the current slide. Man, that would be fantastically useful.</p> http://asianhospital.com/?id=q/1353247 0 App not available under a non-admin user itsmikem http://asianhospital.com/?id=users/433724 2018-08-29T00:40:46Z 2018-08-29T00:40:46Z <p>I created a non-admin account on my Windows 10 laptop with Microsoft Office but PowerPoint is not present. It's available and working fine under the admin account. In the non-admin account, when I go to Windows 10 <code>Settings/Apps/Apps &amp; features</code>, PowerPoint isn't even listed, so there is no "repair" button to click. I clicked repair under my admin account, and it still isn't available in the non-admin account. How do I make it available for my non-admin user account? </p> http://asianhospital.com/?id=q/1352817 0 How to collapse/expand all headings of a specific level in MS Word nam http://asianhospital.com/?id=users/371126 2018-08-27T19:39:16Z 2018-08-29T00:02:56Z <p>For instance: how can we collapse all <code>Heading 4</code> throughout the document in one operation? We are using Office 2016.</p>