วีดีโอ

help.. i can't see that "sheet view" on my view tab... i'm on excel 2019

nice work bro!

Can we automatically update from excel to MSP?

I am facing an issue with heading1 style. So i want to create documents which start with the "Product Code" - "product Description" - "Company Name". e.g. AB-9999 - N&A Apple Flavor - ABC Company I did follow your steps but turns out all files were created with only the 1st 2 Characters of the 1st merged field (Product Code) before "-". After a couple of tries with different scenarios, the conclusion is, Outlined files only create with only one merged field as document name and without special characters like "-&@...etc". Please if you know how to work around, do let me know because I don't want to use Macros.

I did the same thing but i don't know why it always gives me this... "this selection does not consist of heading levels". I did change me first title (from mail merge listing) to header1 but still no success. I am running in Office 2019

The VERY BEST video on how to do this that I have ever seen! I'm forwarding it on to the rest of my team! Thanks for being so clear and covering every possible option.

Thank you very much. May I ask a question, I tried the dropping org position one over the other and when I dragged I do not see them connected and also I put Multiple shapes over the org shape ( Manager), A task shape blank box appears not the selection pop you have demonstrated, is there a setting I need to do? Thanks a ton.

When I select all, and then click ‘show document’ I just get an error saying “the selection does not consist of heading levels” 😞 i have 200 3 page letters to send to partners

Thanks it helped me for work

👍, please also share data file for practice..

it is not working on Pivot Table.. any idea?

I can't use the tag in the private channel and the first google result for microsoft teams leads to a defunct uservoice thread :(

Super helpful video, thank you!

Thanks mate, your music is too loud and your voice volume is too low

Thank you for these cool tips. Is it possible the number arrows? I have created a complex L1 data flow diagram and would like to add number to the arrows in order to create a dictionary for the readers easy to understand a flow, this will also help avoid putting lot of text on the arrow label. Last resort I will do the put number on the label itself and right/ left justify it.

useless

Is it possible to create a reusable template in Visio? For example, I need to create cash flow diagrams for over 250 investments, and while each is a little different than the next, having a starting-point template would be so convenient.

Thanks for this. Very useful. I might well be wrong but isn't April 4th Q4 because the tax year doesn't change until the 5th/6th? How would you take that into account?

Hi I keep getting the message "the selection does not consist of heading levels" though I have chosen heading 1 for the name. Any idea. I have a 3 page document. The name of the employee appears on 3 pages but I have only chosen the first page name as headings 1. Is this why there is an issue?

Very interesting, I'll have a play with that. You had hair at school :P

HOW DO I CONVERT A SMARTSHAPE TO A BASIC SHAPE?

really helpful, thank you! I normally get stressed out and give up. Not this time! :-)

Only works on Samsung phones tho!

Excellent. Thank you!

This helped me so much, thanks for sharing!

Should you save the workbook with the queries in a different location to where the other files are saved? In your example, I noticed the query file (sales report) was saved in a different folder.

its work very nice thank you . nut my document has a logo in the header and when i saved it AS , all the documents has no header. have you any solution to keep header on all the documents?

In this, the 'name' field, which becomes the name of new files should be the first thing on the page. But if we want to insert some data before the name field and still want that the new files should have yhe same name as the name field, then how can we do that? Can we use headers in this and type the data before name field in header?

They forgot to address the issue of hidden columns so it makes it difficult for sheets with lots of columns that you don’t want to see in your view

Unfortunately I keep losing the formatting for the body of the document

Suppose I opened a separate sheet view and filled the blanks up, will that be shown/updated in the original Excel (OneDrive) ?

Hi, thank you for the video. I followed the instructions and even removed my header (rather than add the Macro you provided) and reformatted my document into the simplest possible letter format, but when I went to save the files, it saved only one file with weblinks to the individual documents. Is this because my computer automatically syncs everything I save to OneDrive? I don't know how to get around this. I have about 400 individual wage offer letters to send out via Docusign and I don't want to do them manually.

I have added headings, should you only have 1 at the top of the document? My document is 2 pages, I have removed the page break but am getting the error "The selection does not consist of heading levels." How do I fix this?

Hi, very helpful and really what I needed. After the mail merge I get an extra blank page on every document. There are no extra chars or line break after the signature. Any idea why ?

I can't get my header or footer to appear after doing this, I lose it and it's just text. Any ideas?

Does the content heading will show up as part of each letter? Thanks so much for this tutorial!

So much easier than a nested If.

This will change my reports, I am not good with VBA so finding this solution is great.

Very useful

Very cool

Will come in very handy thank you

Cool Tips thank you

this is a amazing feature of excel. wow; this is going to save lots of efforts of finance professionals like me

This is an amazing information

Super useful

very useful

Great Feature

Great tip thank you.

Very Useful

Great Video! I am a cloud/data architect, is it worth the extra money to buy visio pro over standard?