Replies

No I haven’t. I just checked. I tried setting and unsetting it and it made no difference to this.

In post 411849, Hans has said “If the number format is “General”, Excel will adjust the number of decimal places to the column width.” and this is the effect that I am seeing, but it does not seem to be a generally known fact.

No I haven’t. I just checked. I tried setting and unsetting it and it made no difference to this.

In post 411849, Hans has said “If the number format is “General”, Excel will adjust the number of decimal places to the column width.” and this is the effect that I am seeing, but it does not seem to be a generally known fact.

Well, that’s the point. I don’tneed to get as complicated as the sumproduct formula.

In the attched sheet, G4 & H4 both contain the value 1.5 but I see G4 as 2 and H4 as 1.5

If I widen column G, then the value is once again shown as 1.5

I have included a picture of what I see in D4

Problem solved. I had a faulty dynamic range reference to my database. But what a wierd way to show as an error???

Problem solved. I had a faulty dynamic range reference to my database. But what a wierd way to show as an error???

As a bit of an update on this one, I have discovered that the activecell for sheet 2 can be anywhere in the columns covered by the pivottable and then the refresh will work.

But I cannot seem to move the active cell on Sheet2 without making it the Activesheet, so I am a bit stuck as to how to ensure that I can always refresh the pivottables.

To make things a bit clearer, I’ve attached a sample sheet.

Place the activecell on Sheet2 anywhere in columns A-D and run the macro MD in Module3 and it will run fine, regardless of which sheet is active at the time it is run.

Now place the activecell in any other column on sheet 2 and the “Reference is not valid” error will pop up.

As a bit of an update on this one, I have discovered that the activecell for sheet 2 can be anywhere in the columns covered by the pivottable and then the refresh will work.

But I cannot seem to move the active cell on Sheet2 without making it the Activesheet, so I am a bit stuck as to how to ensure that I can always refresh the pivottables.

To make things a bit clearer, I’ve attached a sample sheet.

Place the activecell on Sheet2 anywhere in columns A-D and run the macro MD in Module3 and it will run fine, regardless of which sheet is active at the time it is run.

Now place the activecell in any other column on sheet 2 and the “Reference is not valid” error will pop up.

On this subject…

When I create a template in Smartsuite, the file description is what folks see in the templates list.

In Office, only the “built in” templates have “friendly names”. Any I create myself are seen as the file name, including the .dot ot the .xlt.

How do I make it so that a friendly name is seen instead of the file name?

On this subject…

When I create a template in Smartsuite, the file description is what folks see in the templates list.

In Office, only the “built in” templates have “friendly names”. Any I create myself are seen as the file name, including the .dot ot the .xlt.

How do I make it so that a friendly name is seen instead of the file name?

Ah yes I see now. The way it was written, I thought that the Ctrl-Shift-F9 was what I had to do afterthey were unlinked.

I just tried Ctrl-A and Ctrl-Shift-F9 but most of the pictures ended up blank.

Seems that the pictures aren’t actually loaded until I page down to look at them.

Is there a better way to ensure that they are all present rather than slowly paging through 159 pages and waiting for them all to appear (I tried Ctrl-A and then F9 but that didn’t work)?

Ah yes I see now. The way it was written, I thought that the Ctrl-Shift-F9 was what I had to do afterthey were unlinked.

I just tried Ctrl-A and Ctrl-Shift-F9 but most of the pictures ended up blank.

Seems that the pictures aren’t actually loaded until I page down to look at them.

Is there a better way to ensure that they are all present rather than slowly paging through 159 pages and waiting for them all to appear (I tried Ctrl-A and then F9 but that didn’t work)?

Sounds good, but how?

Whilst when I do Alt-F9, I get loads of fields that say { EMBED PBrush }, when I go to links, it is greyed out.

Sounds good, but how?

Whilst when I do Alt-F9, I get loads of fields that say { EMBED PBrush }, when I go to links, it is greyed out.

Yeah, I found it there too. I was looking for it in the Word help at first

Yeah, I found it there too. I was looking for it in the Word help at first