New answers tagged

0

Having OneNote open causes this In reference to my comment to the original question, it turns out that in my case this was simply caused by OneNote running. Once I closed the OneNote window, I was able to save an Excel spreadsheet to the Sharepoint drive. I have Windows 10 and Office Professional Plus 2013, Visio Professional 2013, all MSI installs.


0

It appears this option has now vanished from the new Google Drive interface. However, you can still do this through Google Takeout.


0

Go to Format -> Conditional Formatting -> Manage and click Add. In the first two drop-down lists, choose "Cell value is" and "Ends with". In the box, enter ".com" in quotes. At the bottom of the dialog, specify B1:B1000 for the Cell Range. In the Apply Style drop-down, select New Style... Go to the Background tab and choose a bright color, for ...


0

Yes, you can delete the MSOCache folder, if when you install MS Office, you select the option to "Run all from My Computer". Check that option under Microsoft Office, then check Not Available for the components you don't need. I've installed only Excel (tons faster than LibreCalc), Word and PowerPoint, then I've renamed MSOCache to ...


0

If you have a zip file then unzip the package on the drive you have installed windows. For ex: if you have windows on c drive then un pack the installation package on c drive and then run the setup. It will run without any hassle.


0

An undocumented feature of the index tools is the semicolon. You can override the sorting of the item and place it in the order as if it were the new text. For example, if you have two index fields that read as this: {XE "zebra;page 4"} {XE "abbot;page 42"} Then the index will sort it so that zebra comes before abbot. You could apply this each of your ...


-1

you can try Offscrub uninstaller. open a notepad then paste this codes that you can see on this link: https://github.com/PSAppDeployToolkit/PSAppDeployToolkit/blob/master/Examples/Office2013/SupportFiles/OffScrub13.vbs then save as "anyname.vbs" then double click to execute.


1

I've experienced a similar problem when converting from Word to PDF, where whole pages displayed in bold text. After testing, the problem was not the particular monitor or computer and the pages printed correctly. The problem was consistent when I remade the PDF in the same way -- the same pages were always bold. There were no differences in the font styles ...


0

There is a free Message Statistics by Date report available that does exactly what you want. Just select the required folder(s) or the entire mailbox and it will show you the number of sent and received messages as well as their sizes. DISCLAIMER: I recommend this tool because I'm one of the developers, so feel free to ask any further questions.


1

You current command replaces also paragraph mark at the end of the paragraph, so replaced paragraph get merged with the next one. Use this in replace with box: #####^p


-1

Don't use control panel for Windows 10. You adjust from the settings menu - please see the following link as a resource. http://windows.microsoft.com/en-us/windows-10/repair-or-remove-programs#v1h=tab01


1

Option 1: File Tab General under "Personalize your copy of Microsoft Office" "Office Background" change to "No Background" Option 2: File Tab Account "Office Background" change to "No Background" NOTE Try first in Microsoft Word. I've seen some odd bugs reported that it doesn't show up in some of the other applications until you try it in Word ...


0

To whom it still may concern: Workaround 1: Open Adobe Reader. From Edit menu select Preferences, Preferences dialog box appears. Select General category on the list, uncheck or remove tick mark for “Enable protected mode at startup” Simply Close and reopen the application and the embedded object should now open perfectly. Workaround 2: If you are same ...


1

In LibreOffice, go to Tools -> Outline Numbering. For Number, select "I, II, III, ..." For the Before separator, enter "Act" plus a space. Then select level 2. For Number, select "1, 2, 3, ..." For the Before separator, enter "Scene" plus a space. Change Show sublevels to 1. Press OK to close. Now to enter an act heading, on a blank line, choose ...


1

My research turned up, that it is in fact NOT possible to change the installation directory for office. Quoting the references for the Office Deployment Tool: You cannot customize the installation location for Click-to-Run for Office 365 products. Click-to-Run can only be deployed to the system drive which is typically drive C. Source Since this ...


1

Frustratingly, Office 2016 has obfuscated the installer options to "help" people. This thread explains how you can set the options manually including desired components, install location, etc.


-1

I found if I have other PDF files open while trying to insert a PDF into a Word document I get this message. If I close all opened PDF files running in my background I am able to insert a PDF with no problem. Not sure why but that was my solution for my laptop. I have a desktop and I am able to run Adobe Acrobat and install PDF file into word with out ...


0

It turns out that OP had permission issues. UPDATE 1: I just took another look at things and I'm pretty sure my problem is related to Windows 7 permissions. I can't even copy and paste the file due to permission issues. UPDATE 2: This turned out to be a permission issue. The Administrator group had ownership of the folder. I set my user name as owner and ...


0

You need to change the quotes in "<TODAY()". Currently, this is treating the entire thing as a string and never evaluates TODAY(). The correct way to write this should be: "<"&TODAY() As the TODAY() is now outside of the quotes, it is treated as a formula rather than a string. It is then appended to "<", which, hopefully, should give you the ...


1

I'm not totally sure what you require, despite my question in the comments but, it would appear you want to know about a cell (it's properties). Since your comments mention inspect element and firebug I will assume you have javascript knowledge (and therefore programming) and want to understand what properties the cell has (like the concept of a class and ...


0

Excel does not have a built-in command to display all settings for a cell's content/formula/formatting. This is a complex topic and there are several ways to provide information about a cell or sheet or workbook. Formulas - From Excel 2013 and up there is the FormulaText() function that can be used to display the formula a particular cell uses. Ctrl-` ...


0

I'm not sure what the problem was with .NET Framework, but I re-installed in Custom mode, and made sure to uncheck any components that had ".NET" in the name: .NET programmability for Excel .NET programmability for Word .NET programmability for PowerPoint I think these are the only ones.


0

We got the exact same error & fault address. Turned out for us that there were corrupted emails sitting on the POP3 server. Once they were cleared out by logging into webmail, the problem stopped.


1

No need for the [#Headers] argument or the = in the condition - =SUMIFS(Oranges[Quantity],Oranges[Produced In],"California",Oranges[Exported To],"British Columbia") I know it gets sort of confusing when working with [Tables].


1

I had this same problem with files that were being shared via Google Drive. The solution that worked for me was: Open the destination file - i.e. the one that is being linked to. If that in turn links anywhere choose Ignore Links Save the destination file Close the destination file Re-open the master file - i.e. the one you are linking out from. Choose ...


0

It seems there is an issue with Word if you drag and drop a picture in, rather than copy and paste it or insert it. There is a thread here detailing it, it may help to copy and paste, or insert the picture instead. This should then allow you to use the toolbar as expected.


0

I found a solution but it is not optimal: by using Caps Lock, the shortcut works correctly. Obviously this is not ideal if I want to write after some text.


0

You can also use "&" chars to concatenate text in Excel, as below: The clause: =CONCATENATE(A1,CHAR(10),CHAR(9),B1,CHAR(10),CHAR(9),C1) could be written as: =A1&CHAR(10)&CHAR(9)&B1&CHAR(10)&CHAR(9)&C1 This form will be interesting when CONCATENATE overflows (it has a limit of entries).


0

Another option is to first insert a text box and then insert just paste the picture in there. The picture will get the size of the text box. This works well when you are inserting pictures in table cells as well. Just draw a text box object inside a cell. Copy the text box to other cells if you need more and than paste the pictures.


0

it is also possible to download an image (.img) file for offline installation on office.com/myaccount. Just open the link Click on Install Click on Language and install options Click on Additional install options With the link Download offline installer you will be able to download an image file for both x32 and x64 Microsoft Office


0

Another option is to register for free to Apple's iCloud service (https://www.icloud.com/), upload your document there, and download it in either .docx or .pdf format. This of course less than ideal, but at least you can view the document. A more detailed step-by-step description of the process with screenshots can be found here. Unlike the previous ...


0

To get around this for now, I have uninstalled Skype for Business 2016. Re-enabled the Lync component in Office 2013 and installed the skype for business update kb2889923.


-1

I'm using Office 2010 and here's what works for me: On the 'Home' ribbon open the 'Paragraph' option box by clicking the small boxed arrow in the bottom-right corner of the section labelled 'Paragraph.' Make the spacing changes you want then click the 'Set As Default' button at the bottom. All done!


0

No, there is no way if what you need is to hide an area, whatever it contains. You can hide text, as explained in a previous answers, but if the area contains other elements, as for instance tables, drawings, images, mixed with text, you have to hide them one by one. You cannot simply select a part of your page and say: hide this.


1

Run Office on safe mode (/safe) to eliminate the possibilities of errant add ons. Another possibilities will be if the files are saved on the same partition as Office & Windows system files, where the file is originally created on a temporary folder (which somehow disallow compression) and moved afterwards (moving on the same partition won't change ...


0

Try running the command from an elevated command prompt in either of the below two formats. I'm not certain if changing to the root of the "C" drive is necessary if you're pointing to the VBS file with the full path explicitly. The error message almost indicates as if the full path doesn't have double-quotes around it unlike what your example show. ...


0

Yes, this should be possible. Assuming you're on the latest version of desktop OneNote, you can use the equation editor, which contains a bunch of these LaTeX style shortcuts. First, you'll need to insert an equation, which can be done by either using the ribbon or the ALT+= shortcut. _ and ^ will produce subscript and superscript after you type a space. ...


-1

For Office16 I went to the office16 directory (in Program Files x86). There are separate exe (aka Application) files there for each Office component that end with ICO or ICON (ACCICONS, PPTICO, WORDICON) that have the icons. Couldn't find one with all icons. The inconsistencies (ICONS, ICO, ICON) are not mine btw.



Top 50 recent answers are included