Posts by Squire_King

Re: Prevent Review Toolbar starting Automatically

Confirm that by deleting, saving, closing and re-opening, the bar does not pop up.

Are you thinking of creating an add-in that says ...on workbook open, if _ReviewingToolsShownOnce is in the custom properties, then delete it

....or (possibly) simpler ..On open hide Reviewing toolbar ?

Cheers,

Re: Prevent Review Toolbar starting Automatically

Greetings Cell Master,

Compared the two and you are correct...the pre-tweak version has custom properties,
_AdHocReviewCycleID; _EmailSubject; _AuthorEmail; _AuthorEmailDisplayName and _ReviewingToolsShownOnce

The latter seems the offending item. (has no 'value' and type of 'text')

Hope this helps.

Cheers,

Re: Prevent Review Toolbar starting Automatically

Hi Jack,

Quicker than I thought .....I got a colleague to send me an e-mail with XLS, and reviewing toolbar appeared as expected.

Then I talked him through the change and got him to send another e-mail with a workbook. This time NO reviewing toolbar (yippee).

So whilst not a complete fix, it will cut down the amount of occassions.

If you can get further with this, that would be fantastic.

Cheers,

Re: Prevent Review Toolbar starting Automatically

Hi Jack,

e-mailed myself, with a sheet that was causing a pop-up today, and no review toolbar appeared. (Bearing in mind that I tweaked my system, as per Richie's fix).

Then, put the Outlook back to how it was and sent myself another e-mail with the same workbook, and ....no review bar ......hmmm.

Could the fact I've opened it earlier have changed something?.......

I think I'll get a colleague to send me a file tomorrow and then try him with the 'fix' and see if that makes a difference. ....might be mid-day before I can post again.

Thanks for your support

Have a good evening.

Cheers

Re: Prevent Review Toolbar starting Automatically

Wow ...thanks for all the replies guys ....this little 'niggle' is certainly touching some nerves.

I am using Outlook 2002. I have tweaked the option that you pointed to Richie, thanks, but after testing it must need those sending to set this for me not to have the pop up.

I can cut down on the number of times this happens, as there are a lot of regular 'senders', but not all.

Agree with Jack, I would be grateful of knowing a 'one time fix', along with some of my colleagues.

Many thanks

Cheers

Re: Prevent Review Toolbar starting Automatically

Thanks pangolin,

I had been there thanks ...but it's not fixing the problem...all the time anyway ......some workbooks open fine without the Reviewing Toolbar popping up ....but others do.

This particularly happens with Workbooks I haven't opened before (i.e. from emails) ...And as I'm opening about 50 plus a week, this is why it's a niggle!

Any further help out there appreciated.

Cheers,

Hi All,

Did try the search first, but couldn't see this one...

I've currently using Excel 2002 and every time I open a workbook the "Review Toolbar" pops up .....how can I stop this, as it's a pain!!!!!

Cheers,

Re: Exported Report to be split across sheets

Hi Alan,

Yes thanks, very aware of exporting Access reports to other packages, like Excel and Word, don't look the same.

These reports get sent to external people that do not have Excel, whom are then using the information as part of other Workbooks. The request is to have the data split by the product or customer (depending on the report).

This is being carried out manually at the moment and I hoped there was an easy way of doing this from Access .....if you have another method, that would be great. ...I suppose I could look at a macro in Excel once data has been exported .....but I'm trying to keep the KISS principle in mind.

Cheers,

Re: Formatting Chart Tables

Hi Andy,

Appreciate the reply.

The A-Z order, I thought would be the same as input, indeed going back to the series order it is how I want it, but the third data set is appearring at the end of the data table....

I think I will look to use your cell method.

Many thanks

Cheers,

Hi,

Using Charts with the option of a chart table. Two questions:

1 - How can I format the numbers in the table?

2 - How can I sort the table's row Names (simply A-Z)?

Thanks for any help

Cheers,

Re: Exported Report to be split across sheets

Thanks Norie, I had read this post before submitting mine, but as I couldn't work out how to fit it in with what I'm doing (as it's a bit beyond where I am in Access), even though in a similar area.

The Report is in the right format, I was hoping there was a quick way of creating a macro, like using "Output To" as I normally do, to achive the result.

If you think that this is the only way to achieve this, then I'll have to re-think.

Cheers,

I have some reports that show data by product type, where it starts a new product per page or data by Customer, where it starts a new customer per page....all of which is fine.

What I would like to do is export the reports to Excel and for each product, the results appear on a different worksheet, with the 'tab' being the product name (rather than all on one sheet with excel grouping) ...similar with the Customer one.

edit: thanks WillR, should have been more explicit these are Access reports

Hopefully, this makes sense!!

Cheers,

Re: DSUM trouble

Thanks Derk, I think the posts went in at about the same time.

Whilst I tried your version, I couldn't get further with it .....so I ended up with my alternative, which was a find & replace style macro, which added a dot after the groups with single names, like Customer.

As this is a monthly sheet, it changes all those problems on the active sheet in under a second...

Appreciate you help though.

Hope you have a great day 'across the pond'!!!

Cheers,

Re: DSUM trouble

Thanks Shades....the thought had crossed my mind, but those were examples of a huge sheet containing some 6,000 similar variations.

I suppose getting VBA to check if there is only one word, then add a suffix, is an option, but I was hoping to keep the data untouched, and just use formulars/functions to analyse it.

Cheers,

Re: DSUM trouble

Hi Derk,

Thanks for the quick reply!!

tried "=Customer" in the criteria and got #N/A ......tried ="Customer" ....and got 80 ......then tried =Customer and got #NAME?

Is there a way of altering the formula?

Thanks

Cheers,

I'm using the DSUM function which I thought was working well, but it has a slight floor.

Background

The DSUM looks in my database sheet called "JUL04" and sums data in Column F, if they meet criteria on my set up sheet (O4:Q5) ....giving me DSUM(JUL04!B5:AG65536,JUL04!F5,O4:Q5).

Now, the criteria includes customer names similar to Customer, Customer 1, Customer 2 etc

Lets say Customer Qty = 10, Customer 1 qty = 20 and Customer 2 qty = 50

Users are picking criteria from a drop down box.

If the users picks Customer 2, then it returns 50 ...fantastic
Similarly, if the user picks Customer 1, then it returns 20.

My problem is with the Criteria of Customer, as it returns 80 ....almost as if the criteria was Customer*

And so to the question...

....after all the intro, is there a way to get Customer to return qty as 10?

Thanks in advance for any help

Cheers,

Re: International Version Awareness

Hi Dave,

Doh! how did I miss that!!! ....

Many thanks

hi,

Can't find how to do this and hope someone can help.

I'm sending out a workbook to some European Directors, from the UK, and some are saying that the formats for dates / numbers are not right.

Whilst I could create a button for so that the dates change to mm/dd/yy format (rather than the dd/mm/yy in the UK) and numbers have dots instead of commas, for 'thousands & millions' ....is there a way that I can set this so on opening Excel checks some "international version" setting and updates accordingly??

Thanks in advance

Cheers,

Re: Forum improvement

Thanks to Dave for this feature...it's great!!! Already helping to save time to get to solutions.

Many thanks

Cheers,

Re: YTD formula trouble - Solved

Many thanks Willr, you're a star!!

The second version worked a treat.

Many, many thanks

Cheers,