Replies

OK. Thanks, all. I’ll look at specific suggestions when I go home. What I’m hearing is that except for the moving and sizing handle, tables SHOULD function much the way they did in 97. That’s what I wanted to know. In this particular case, I get to delete a large row, so I’ll be back on one page anyway.

I thought of more funny things. I can’t remember why I copied the top three lines to a new document, then copied the rest from the original document to a new document, positioning my cursor in a new line at the end of the table. It put the whole pasted text at the beginning of the table, and the original lines at the end were not positioned correctly. When I cut the original lines, positioned my cursor at the first position in the table and did the paste, it pasted the original lines into the first cell. That used to work ok.

Also, when I try to select the top line of the table, it takes me to the end, unless I do it very carefully.

As I write this, it does sound as if I have the whole table inside a table cell. I originally created this table via convert text to table. Does that do a table within a table?

I haven’t had trouble before, but maybe I haven’t had a table go over one page. I did install that cheap pdf maker, that has caused one friend to not be able to read this file (when opening the Word .doc from mail, Acrobat opens and says ‘does not begin with %pdf’). I wonder if it’s doing other things too. I had NOT saved this as a pdf before the friend’s problem happened. I don’t have text next to the table, and I’ve been using tables for years, so I don’t think I was doing anything funny. Definitely no table within the table.

Funny – the one thing I DO like is the handle that lets me reposition the whole table. I wondered if the graphic-type handling was what was causing it to keep the table all on one page. But other than the problems I’m having, what’s the bad news about this feature?

Well I got it to work by doing a new data sheet and then the chart. I entered all the dates, then just the min and max values for Sept 7. Then I did the chart. The line was just where it belonged. The values were exactly the same as in the original chart where I had added that series last. Then I copied the rest of the values. Now it looks fine.

I don’t know what I’ve learned from this. Is it a bug or can you not expect to enter a new series to an existing chart and expect it to show up in the right place if the series doesn’t begin at the first x axis value?

Charles is right that you don’t want to turn off the message. If you find the setting that says ‘Prompt to save normal template’, and if you select that, it will do the changes without asking you, and that could be bad.

If you add or make changes to styles, or I think add to your dictionary, or change some options, those changes would be saved in normal.dot. If there are things you do every time because you always want documents done that way, I would start a new document, do those things, close Word and let it save normal.dot (as Charles said). What I think is not so good is doing who knows what all in a document and then saving changes. It’s better to save normal.dot after you’re aware of just what you’ve done.

I still don’t get it, but I had another puzzle yesterday, and this seems to have the same problem. I did get an almost vertical line on the first date on the chart. I’m hoping for a very vertical line on a particular date further on in the chart.

Here’s what I did, so you can tell how lost I am. I added a row to the data for the sep 8 saturday, and on that row entered in two previously unused columns the bottom and top values on my scale. I highlighted the two new cells, did CTRL+C to copy them, went to the chart sheet, did a paste special, selected new series and categories. After that gave me the almost vertical line on the first date on the chart, I deleted that, went into format series, did an Add, selected the new cells as the data values. The results were the same.

The cells are on a row with the Sept 8 date in column A, which is within the range of the Category X axis labels. The almost vertical line shows a date of August 14.

This happened to me yesterday when I tried to have one line for the dates from August 14 to Sept 7 and another line starting at Sept 10 to the present. The data values show correctly when I check them in Format Series, but both lines started at August 14. The second one had the values for the cells starting on Sept 10, but the date points showed August 14 , 15 etc.

Maybe what I didn’t understand yesterday is what I don’t understand about my vertical line today. I suspect that it would help to understand what the word series means what makes lines part of an existing series or not.

Also, it would be nice if it really were vertical, but that’s minor.

Ok, I got a vertical line (well bar) by changing the chart type for the series for the one date (Sep 8) to a bar chart. But it’s still showing as Aug 14. There’s now a gap in the other series lines between sep 7 and sep 10. I wish someone could explain what I don’t understand here.

My question is similar to the question in post number 72609 where the poster wanted a vertical line on today’s date. I have a chart with dates for monday to friday each week; we made a change on a particular saturday. I’d like a vertical line on that saturday to indicate where we expect to see a difference in the chart figures.

When I insert a vertical line using the drawing toolbar, it moves each time I add a new day. I also have a comment pointing to the vertical bar, and it moves as well.

I’m pretty much a beginner and did not understand the explanation in the other post about a new series and scatter chart. I’m using a line chart. I tried adding min and max values to rows that show the saturday date and pasting those cells using paste special, but I just got a two column blank space on the chart.

I’m hoping that since my bar should stay on the same date, my solution might be easier. I don’t care if I use the drawing toolbar or some calculated line. I hope someone can tell me how to get the vertical line and comment to stay put on the specific date. Thanks.

Thanks for all the advice, Charles. I have two questions.

When you say “A gentler way would be to have one small global template that contains the macros to load other global templates as needed. Have that small global template loaded automatically”, what does “loaded automatically” mean? I do not think I can take a solution that involves making a change or installation on other people’s computers. How else do you load a global template automatically?

You mentioned in this and your other note that a global template should not be kept in the Workgroup Templates folder. Why is that?

Well, PHOOEY, now it abends. I have renamed the AutoNew to GetTheAddIn, called that from AutoNew and also from the new AutoOpen. I can create a new template from this template (was SUPPOSED to be my standard starter template), but when I based a new document on the second template, it abended. Three times.

I didn’t think that had anything to do with this thread but when I deleted the AutoOpen and saved the second template with a new name, I WAS able to base a new document on it and did not get the abend. Now I’ve opened the second template without the AutoOpen, ADDED the AutoOpen and saved it with a different name. I WAS ABLE to base a new document on it and re-open that document (closing Word each time). The toolbar is there so the AutoOpen works. The template with the AutoOpen works; there’s just something flaky about it that will embarrass me by abending on my co-workers at inopportune times. Still phooey.

Have a nice weekend all. We have Monday off (BC Day).

If you’re asking will it work to have it there, yes, you can put a shortcut or link to a template on the desktop and clicking it will open a document based on the template. Since it’s a shortcut or link and not a copy of the template, it will always go to the current version.

If you’re asking how to get it there without manually putting it there, I’m bowing out.

Legare, that’s so cool. Now it’s blank and I can get B2 to say the same thing in the cell and the entry area. Thanks very much for your time and the explanation.

BAM, I can’t have a solution that depends on a configuration on the user’s machine. We have too many users: staff onsite, contractors onsite with laptops, contractors offsite connected to the lan or not. We keep getting new machines (poor us) and I can’t even get the installation people to agree to set up the Workgroup Templates Directory. If the users are not connected to the lan, I have instructions for them to get the common macro and put it where they put the rest of our templates and when I’m trying to find it to add it in, they get to tell me where that is (this last bit would work WAY better for them if I knew how to bring up the browse dialog box and use the location they identify from the dialog).

I like the startup folder on the LAN idea, but I still need to try to find the add-in for people not on the LAN, so I think I may as well just add it for everyone. I’ll entertain rebuttals to this last thought.

Thanks, Legare. I don’t know much Excel. I’ll bet you’re right about this, but all I see in the cell now instead of the 0 is the formula that I keyed in from what I thought you wrote: =IF(Mandatory!C30=””,””,Mandatory!C30) (I’m using the right cell references now). The idea was to see a blank. I have formulas UNticked on all sheets in Tools | Options | View.

Actually, I made a copy of the workbook. Here’s exactly what’s there. In the original, Summary!C2 has a formula: =Mandatory1!C30. Mandatory1!C30 is right now blank. But cell Summary!C2 shows 0. In the copy, Summary!C2 is where I have your formula, which shows the formula itself, where the formula =Mandatory1!C30 used to show a 0.

I wonder if there’s just something wrong with the workbook. In another cell, I have different things showing in one of the corresponding cells in the original and the copy. In the original, Summary!B2 shows in the keying area on the toolbar a formula: =Mandatory1!B30. In the cell, it shows the formula from Mandatory1!B30: “=IF(B4=”Yes” and B7=”Yes”,”Yes”,”No”)”. In my copy of the workbook, both the cell and the keying area for cell Summary!B2 show: =Mandatory1!B30. I had tried your formula there and then changed it back to what it was. Why would this be different in the two workbooks?

All the B2 and B30 cells are formatted as text. The C30 cells are general. It hasn’t made a difference whether the C2 cells were text or general. I really have checked many times for the Formulas option, and it really is off everywhere.

Thanks for the replies, BAM. The AutoNew IS in the template the document is based on, and now I get to update all those templates with an AutoOpen. They’ll both just attach the global template.

If I had a DocumentChange event in the global template, don’t I still have the problem of attaching the global template so the document can find the DocumentChange event? Am I really missing something here?

It’s a bit confusing, my use of ‘global’. It’s workgroup global (meaning a template on the LAN that’s used by all the templates), not Startup folder on your own computer global.