Forum Widgets
Latest Discussions
Text Form Field Expression - Calculate Average but Ignore '0' or 'N/A'
Good Day All, I am making a Job Review Word form that is based off a numerical ratings system. I would like to take the average of all the numerical ratings, currently =Average(ADP,Fit,TimeAway,Calendar) is working great. (see pic) What I would like to do is calculate the average of the ratings but ignore any values that say 0 or N/A. In excel I would be using the AVERAGEIF function, but I cannot get that to work here. Does anyone have a solution that I am missing?
Word Online (Web version) auto deletes text
When typing on Word online (web version) using a mobile device (Galaxy S22 Ultra, Tab S8 Ultra, iPad Pro (M1), etc) Word will randomly start deleting all of the text typed. For example, you start typing a sentance, and you hit enter, it deletes all of it. If you hit backspace it deletes all of it. Sometimes it deletes portions of it. I have noticed that it seems to happen during the "Auto Save". I'll be typing and i see the autosave message come up and that is when it deletes the text. I have tried this on Google Chrome, Microsoft Edge, Firefox, and Samsung Internet browser. I have tried it on Safari for the iPad Pro, and it has the same effect on all of them. If you are wondering why I want to use the web version of office instead of the application available for Android and iOS, its because selecting text in the app is horrible. You cant highlight text by putting your mouse cursor up to it and then selecting it, then dragging the cursor to select the text you need. It's incredibly frustrating to sit there and try and highlight some text 100 times without it being effective. I use Samsung Dex which is a great tool for getting more out of the phone. I would happily use the native applications for Office if they allowed text to be selected properly. As mentioned i have tried several browsers, across iOS and Android. I have restarted the phone (and tablet) and factory reset the phone (twice) and the tablet (once), and the iPad (twice) thinking it is something with the devices, but clearly that isnt the case. (Even skipped restoring the phone from a backup altogether once just to make sure i didnt contaminate it with previous data) If anyone has any idea on how to address this, please let me know. If anything get Microsoft to fix the web version of Office for mobile devices.
VBA to set logo in the header as Decorative
I have macro code to set Alt Text for small images in a document to Decorative. Sub alttext() Dim shp As InlineShape Dim doc As Document Set doc = ActiveDocument For Each shp In doc.InlineShapes If shp.Width >= InchesToPoints(2) And shp.Height >= InchesToPoints(1) Then shp.AlternativeText = "Figure. Caption." Else shp.Decorative = True End If Next shp End Sub Works great. However, it overlooks the image in the Header for some reason. I need to set Alt Text for my logo in the Header to Decorative. I cannot seem to figure this one out. Please help.
Word replaces document images with images from other documents when executing a print function
I create a document with images/photos placed throughout the document (the pictures have been copy/pasted from a non-Word source, ie., websites, etc.); some are located "in line" with text; some are located "tight"; and some may be "in front" or "behind" text. Everything looks just as I want. So then I execute a print either to a PDF or to my default laser printer (the problem occurs either way; the problem occurs simply when an executing a print). The images in the origin document (and therefore the printed result) change to an image I used in another document, sometimes from a previous day. The images swapped in are placed in the exact same position with the same formatting and size as the original image. If the original image was 2"x3" and the swapped in image was 4x2, Word distorts the 4x2 image into the 2x3 space.Word just randomly (I have not determined how it decides) swaps out my chosen image with another (the image swapped in is always from another Word document always from the same PC (I use MS Word on other PCs on the same local/home network). This is MS Word 2010.
Files opening in Read Mode
For the past day or so, all the files I'm working on are opening in Read Mode instead of Print Layout, the only View I use. I've searched every option for a solution to this but found nothing. I know I can click on View in Read Mode and select Print Layout, but 1) I shouldn't have to take this extra step, especially since I've never ever ever used Read Mode and my files have always opened in Print Layout until now, and 2) the program freezes for several minutes when I try to enable Print Layout mode. I'm using Microsoft Office 365 and Windows 10. I edit book manuscripts and need to streamline the process any way I can. I have not changed any settings in Word.Multiple shortcuts suddenly stopped working.
Normal keyboard shortcuts such as ctrl+C, ctrl+V, ctrl+Z, ctrl+Y, and ctrl+S suddenly stopped working for me. Some shortcuts still work, for example, ctrl+B or ctrl+U. I have no idea what caused it, and when I click 'Reset All' in the Ribbon Customization menu it doesn't get them back. Furthermore, I then readded some of these shortcuts manually and reseted the list, and it did delete the new additions, but didn't return the old hotkeys. It oddly looks like the original list was somehow hardwired not to include some of these shortcuts anymore. I tried reopening Word and restarting my computer, but it didn't work. What options do I have to my avail? Thanks a lot to whomever can help
Word to PDF, issue with gradient colors
Hello all, I've got a simple shape in Word filled with a gradient color. As I "Print" or "Save As" the Word document in PDF, the color gradient is not showing properly in the PDF file. In Word, I've already been in Options / Display / and selected "Print background colors and images", but it doesn't change anything. Please can somebody help? This is how it looks like while I'm in Microsoft Word And this is the PDF result as I do Print in PDF or Save As in PDF from the Word document.
