Excel VBA code to extract information from other workbooks
The code is looking to go to a destination folder which is stated in the dashboard sheet (for example C:\DOCUMENTS) of the main workbook and open each .xlsx or .xls files (using wildcard *.xls*) in the folder and take cells A1:C1 (this is fixed) from…
Microsoft 365 and Office | Excel | For home | Windows
Resource usage different between Gantt chart and resource view - Project 2010
I have a recurring (but random/sporadic) problem with Project, where the resources assigned in the Gantt chart view don't match up with the resources assinged in the Resource Usage, or Resource Graph, views. In the Resource views the resources will…
Microsoft 365 and Office | Access | For home | Windows
EXCEL - PIVOT TABLES - creation without autofit columns
I want to create a pivot table in Excel, but i dont want it to adjust the columns of my Excel sheet. Do you know how to do this before you create the pivot table? I know how to do it after i create one.. I just go to options and then unclick autofit…
Microsoft 365 and Office | Excel | For home | Windows
Unable to delete Word file in an Android Device
I am trying to delete a file but Word (android GalaxyNote5) is saying I do not have permission to delete **The post was moved to the appropriate forum category by the moderator.** ***Subject edited for clarity by the moderator.***
Microsoft 365 and Office | Word | For home | Windows
Excel Statistics - Chi square test not working properly
Hello, I have been trying to code chi square test in Excel I have been successful in using chisq.test and getting the correct p value. However, when I try to calculate the value for X2 through chisq.inv.st the result is different from what it should Just…
Microsoft 365 and Office | Excel | For home | Windows
Take IP address and reverse the order
I have an IP address that I need to "flip" or reverse the order on. For instance, I have IP address 12.345.6.789 in cell A1 and I need it to be 789.6.345.12. I've been playing around with different formulas and cannot seem to get this down!…
Microsoft 365 and Office | Excel | For home | Windows
Opening Office-Document via ms-word:ofe on iPad
Hi everyone, I have a WebDAV-Server that provides resources like e.g. Office-Documents. Our small web client provides the possibility to open and edit this documents by using the office URI scheme (e.g. ms-word:ofe). For example when you click on a link…
Microsoft 365 and Office | Word | For home | Windows
Office Word/PowerPoint: forward delete button hardware keyboard does not work as expected
My favorite hardware keyboard for my iPad is the Logitech K380 (http://www.logitech.com/en-us/product/multi-device-keyboard-k380), which has separate backspace (delete character to left of cursor) and forward delete key (delete character to right of…
Microsoft 365 and Office | Word | For home | Windows
SharePoint Online crawler not crawling all items from the list
Hi, We have developed a page in SharePoint Online 2013 to Search items from a list using Content Search webpart. While searching for a particular item for Title field it doesn't show up in the Content Search webpart results. Also when the item is…
Microsoft 365 and Office | SharePoint | For business | Windows
Why pin a template?
Hello, I am creating some personal Templates .dotm in my mersonal templates folder. One of the things that I can do after creating one is pin it. What does pinning accomplish and why would I want to do it? Thanks, Raney
Microsoft 365 and Office | Word | For home | Windows
How to send a powerpoint & excel doc via email containing linked graphs
Hi, I created a file in excel with graphs I have Paste Special on my power point doc, linking the two together. When I change certain criteria on excel, it automatically updates my powerpoint graph. I need to send these files out to my team so when they…
Microsoft 365 and Office | PowerPoint | For home | Windows
Can I use word 2010 to batch convert to PDF
Hi all, I'm trying to convert a load of word documents to PDF, before I used to use Adobe Acrobat Pro which seemed to work fine, however I have a batch of files were there seems to be a constant error "unexpected error occurred . *pdfmaker was…
Microsoft 365 and Office | Word | For home | Windows
Logon Session Timeout on Office software (word, excel, Skype... )
How to auto sign-out user from thick client software such as MS WORD, Excel or Skype? \ Currently, with valid license token of Office 365 pro plus, user will be able to use MS word, execl or Skype. but session does not timed out or no way to enforce…
Microsoft 365 and Office
Renaming UserForm Controls
I have a large project that will have many (~15) userform Frames, each of which will contain 600 controls (150 labels that are captioned at run time and 450 option buttons (150 groups of 3). Having gone through the tedious task of setting up the first…
Microsoft 365 and Office | Word | For home | Windows
Exporting Crystal Report for Word email merge
Hi, I have a renewal letter written in Crystal Report – each page with unique Permit Number, fields that CAN GROW, and subreport of VARIOUS number of fee lines. This year I need to email this letter to permit holders. How should I reformat the report to…
Microsoft 365 and Office | Word | For home | Windows
CVR nummer
hvordan får jeg indsat mit CVR nummer i profilen i min 365 business premium?
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Text Disappears from Saved Cover Page
I modify a cover page and save it to Cover Page Gallery. When I insert the cover page into a new document, the text appears for 1-2 seconds and then is missing. The cover page on the left (with red text) is what I insert; the cover page on the right is…
Microsoft 365 and Office | Word | For home | Windows
Multiple Owners for a Form
Being able to collaborate and have multiple owners on a Form would be great. This would also be great to share live results rather than sending multiple, updated results.
Microsoft 365 and Office | Microsoft Forms | Other
Justified alignment in headings
Hi community forum. I have an issue which I hoped some of you can help me with. I want to align a single line in justified manner. Currently if you do so, then the last line is left aligned meaning that single lines like headings cannot be aligned…
Microsoft 365 and Office | Word | For home | Windows
Multi Level List won't continue when I press enter
Thank you, Suzanne S. Barnhill Doug Robbins - Word MVP and especially Stefan Blom. You are all knights of the answers.microsoft.com all providing positive atmosphere of discussion. This is better if it would be an atmosphere of information vacuum.…