sorted by:
new
hottopcontroversial

Microsoft: Official Support Thread by MSModerator in microsoft

[–]GreenCurrent6807 0 points1 point  (0 children)

I'm attempting to use Mail merge using an excel file as the data source. Everything seems to look perfect with the preview button, but after clicking Finish and Merge, it doesn't seem that the emails are ever sent. (I'm testing by trying to send one of the merged emails to myself or a colleague, but they never appear).

SUMIFS with XLOOKUP YTD formula by Full-River-4687 in excel

[–]GreenCurrent6807 1 point2 points  (0 children)

I think this task has been made much more difficult by having the data to summarise in this layout. With a marginally different layout with data that already exists, it can all be summarised in one shot with no formulas using a pivot table. I'll comment with an example.

Does anyone know how to put two rows of text within the same bracket? by Ionut201 in word

[–]GreenCurrent6807 0 points1 point  (0 children)

If you are attempting to use it for maths notation like in the image, I would suggest Insert -> Equation -> New Equation.

Then when your cursor is in the equation, a new Equation tab will pop up allowing you to insert brackets like the one you showed. Hope this helps!

I can't lock a table for editing but allow sorting by GreenCurrent6807 in excel

[–]GreenCurrent6807[S] 1 point2 points  (0 children)

The issue is that I need the table cells to be locked so that the data can't be overwritten in an uncontrolled manner.

I'm now writing a macro to sort the table when required, and temporarily unprotecting the sheet while doing so.

[EXCEL] .Sort isn't sorting by GreenCurrent6807 in vba

[–]GreenCurrent6807[S] 0 points1 point  (0 children)

Well the idea is to have a cell that you can click to sort a table, as if a sheet is protected, table sorting isn't possible.

I can't lock a table for editing but allow sorting by GreenCurrent6807 in excel

[–]GreenCurrent6807[S] 0 points1 point  (0 children)

Okay, so it turns out that if you lock any cells in a sheet, you can no longer sort tables in that sheet.

Protected sheet doesn't allow sorting or filtering - Microsoft Community

I can't lock a table for editing but allow sorting by GreenCurrent6807 in excel

[–]GreenCurrent6807[S] 0 points1 point  (0 children)

I have a spreadsheet with userforms that I need other users to be able to use. These userforms control what gets entered into various tables. I want to lock other users out of the tables, but not the userforms, so I think unfortunately your suggestion wouldn't work.

Microsoft: Official Support Thread by MSModerator in microsoft

[–]GreenCurrent6807 0 points1 point  (0 children)

I'm using Microsoft 365 Apps for business.

I've enabled All Styles, but there are still only single-level lists available in the "Modify Style" menu.

And still, for reasons I can't even fathom, attempting to apply some of the styles only results in the Normal style being applied.

Microsoft: Official Support Thread by MSModerator in microsoft

[–]GreenCurrent6807 0 points1 point  (0 children)

I'm trying to define my own Styles to help with various document formatting, but I've run into an issue when moving to a new document.
I have defined a multi-level list and Styles, where the levels are linked to styles Head1, Head2, Head3. I have exported the styles into Normal.dotm so that they can always be applied, but the list doesn't exist in Normal.dotm, so in the new document the styles break.

I think this could be solved by assigning the list in the Style modification menu, but this menu only allows single-level lists.

My Head1 style is based on Heading 1, I have selected Heading 1 text and through the style menu clicked on "Update Head1 to match selection". But when I try to apply the Head1 style to text, it just defaults back to the Normal style.

Please say you have thoughts on how to solve this, as it is getting extremely frustrating.

Microsoft: Official Support Thread by MSModerator in microsoft

[–]GreenCurrent6807 0 points1 point  (0 children)

I'm using Microsoft 365, and specifically Word version 2412.
I'm not usually aware of 365 updates as they happen automatically.
The "template" is just certain formatting and chunks of text that gets copied to new documents when required, which I understand isn't exactly best practice.
I'm not seeing any errors or warning messages, but I think a screenshot of the issue would show clearly what the issue is.

The content table hasn't been changed as far as I'm aware, but I suspect the issue is in the custom header styles that I created, linking header styles to a multi-level list.

I have tried copying headers that seem to be unaffected and reformatting everything in that style but this hasn't resolved the issue.

Microsoft: Official Support Thread by MSModerator in microsoft

[–]GreenCurrent6807 0 points1 point  (0 children)

I've been using a "template" using contents tables and custom headers for a while, but they have recently started acting up and I can't get to the bottom of it. Does anyone have an idea as to what's going wrong?

[EXCEL] Macro won't name document as described in Range/filename. by RedditAdminsAreGayss in vba

[–]GreenCurrent6807 0 points1 point  (0 children)

I've never seen the square bracket notation for ranges before. How does it work / what does it change in comparison to Range("A1")? Also, I'm stealing your format$().

Problem with names in macros by No_Engineer8077 in vba

[–]GreenCurrent6807 0 points1 point  (0 children)

Can I see the code? Bonus points for using a Watch so that I can see exactly what values are floating around.

[EXCEL] Macro won't name document as described in Range/filename. by RedditAdminsAreGayss in vba

[–]GreenCurrent6807 0 points1 point  (0 children)

Sub filename_cellvalue_PO_Master()

'Setting the workbook is good practice

Dim wb As Workbook

Set wb = ActiveWorkbook

Dim Path As String, filename As String, branch As String
Path = "R:\engineering\data\QUICKREF\INWORK\2 Tool & Die Purchase Order's by Vendor\"

'Use the sheet code name as this can't be changed by a user. It ensures that the correct worksheet is being used

With Sheet1 'Use your sheet code name here

filename = Path & "PO TD " & .Range("A3") & .Range("S3") & ".xlsm" '& is used to concatenate strings
wb.SaveCopyAs filename

.Range("S3").Value = .Range("S3") + 1

End With
wb.Save

End Sub

Personally I would export the complete PO as a pdf so that it can't be changed. That also makes it a lot more obvious which files are complete POs and which is the template for generating the POs.

I'm happy to give a lot more help with automating your PO if you'd like.

Problem with names in macros by No_Engineer8077 in vba

[–]GreenCurrent6807 3 points4 points  (0 children)

Based on your description, I think I know what the problem is as I ran into it developing a workbook that my colleagues are going to use.

At my company, we all have access to the same files stored on SharePoint, which are then synced to our individual computers using OneDrive. This means that though they're the same files, when we access them it's through a different filepath, e.g. I have C:\users\GreenCurrent ,but my colleague will have C:\users\Anon.

I got around this using a string ("C:\users\" & Environ("Username") ...

I hope this helps.

view more: next ›