Recent content by kilroyscarnival

Oops, I thought I had posted a reply at the time! I did try this but it didn't work for me. It's not a huge thing, was just curious. Hopefully I'll eventually get reports all based on newer templates so I won't have to go into Style Manager and alter those. It was fun trying though. Thanks...

I tend to work on other people's documents, and some are made using old templates or editing old reports. I use Styles a lot, whereas in the past they weren't always used. I've been using headings 1-5 regularly, but in order to get them into the Styles pane, I have to go into Manage Styles and...

Isaac, thanks for all your thoughts! I finally figured out what I guess I was doing wrong. I made the named ranges again in the same workbook, but as I was making them I chose the scope as "worksheet" rather than "workbook". So, my named range for the dynamic L1, "_L1", was...

If only a pivot chart would meet this need. The data represents actual surface measurement of pavement thickness on a road, so they want the line chart to parallel the irregularities to indicate places where stress and wear are occurring, and be able to hone in on ranges (thus the dropdowns to...

Recently we upgraded to Office 365 and I'm slowly exploring what's new in it. (Excited about the XLOOKUP and FILTER options!) I've been tasked with creating some dynamic (interactive) charts with bulk amounts of Excel data (upwards of 1,000, perhaps sometimes 10,000 rows, and multiple columns...

Yeah, I'm sorry, and I appreciate your ideas, but so far even the changes I've made to the template have fallen on deaf ears. I'm finished exploring this for the short term. Thanks, Ann

Thanks! I will keep that in mind. So far so good with the content controls. As I've been revising documents this week I've been itching with impatience to correct the repetitive simple little formatting errors. I realize I'll have to see if I can take some time in their monthly learning...

Yes, that's one of the things I've been working on in building a new version of that template. In a lot of cases, the users haven't been using the styles at all, and thus the TOC ends up being a mess I end up sorting out. When Styles are consistently applied to the headings, it works fine. In...

(Mon afternoon) Wow, a lot to take in here. Thank you for all this work. I'm trying to find time to work/play with it a bit. The use of content controls definitely solves my don't-accidentally-delete-it issue. First off, I had to figure out why the document properties was grayed out in my...

Yes, reports go back and forth in a review process where a senior engineer edits (and usually gives me the markups to change). Usually the main title page details I wanted to cross-reference don’t change, though. But if an older report were being used as a template, it would be useful to be...

I appreciate all these ideas. But these details in each report would be collected by the engineers and manually input, because every project and site will vary as to all those descriptors. I think those are just suggestions as to what info goes where, but not verbatim. These reports aren't...

Crystal, those field associations sound about right - except I would maybe leave CLIENT for a possible future client name field... and use DESTINATION for the Location field. (I think that’s the field I was thinking of... Saturday brain and I’m not in front of Word.) Another goal is to get...

Crystal, thank you so much for your thoughts. The YT guy's method actually does work for simple purposes, but agreed, I did rename the controls the one other time I used it. Word is something that I only used for the most basic purposes until a change in jobs (I've used Excel more...

Thank you, Crystal! Yes, I have "show bookmarks" selected in my Options. I was looking for a way to force that option onto all users of this particular document. Since it's a user setting and not a document setting, I'm not sure that's possible. And I'm not sure whether I can protect the...

I'm using Word 2010, though I'm pretty sure there are others in my office using a newer version of Office. I'm trying to streamline some old document templates to eliminate mistakes, formatting issues, etc. One thing is that some items get placed several places within the document: 1) title...