Replies

The person in question has told me she was using DoCmd (presumably DoCmd.OpenQuery). Searching on the web does suggest a series of these can run asynchronously. (Presumably because each opens a separate connection?) She’s solved the problem for now with DoEvents. I’ll pass along the bit about enclosing a bunch of Executes within a “With CurrentDB”. Thanks.

I was asking on behalf of somebody else. (That’s why I said “Apparently…”, since it didn’t actually happen to me.) I’ll see if I can get more details as to how they think this is happening.

Hi Ruth,

Behind the scenes, dates are just regular numbers. 1 is equal to Jan 1, 1900, 2 is Jan 2, 1900. Not surprisingly, 61811 days later is March 24, 2069. So that’s normal.

There must be some special format to allow you to enter a date without delimiters, but I don’t know how to do that. But if you can do it at work, you should be able to do it at home – there’s no difference in the Excel in the different packages, as far as I know.

(In that case, how do you handle something like 12311? Is that Jan 23, 2011 or Dec 3, 2011?)

Edit: The little research I’ve done online suggests that there’s no normal built-in way to enter dates the way you want, but that it can be done with VBA. So maybe somebody has added that to your Excel at work.

I ran across an old reference somewhere that suggested this might work if you move your mouse pointer over to the second screen (the large monitor) and click on the links there. (If that’s something you haven’t tried, yet.)

I will be using my laptop connected to a large monitor for several presentations over the next few weeks. I have a Dell Studio XPS 16 and am using PowerPoint 2003. I have not been able to get Presenter View working and then we upgraded from Vista to Windows 7 and now it works! However there is a problem.

If I have a link in my slideshow, there doesn’t seem to be a way to select them in Presenter View. When I pass the mouse over the links, it doesn’t change and when I click, all I do is advance the slide.

I was so excited to be able to run Presenter View and now it may not work. Does anyone have any suggestions? Thanks.

The quick answer is that COUNT only counts cells with numbers – not blank cells, or cells with text – just numbers. You might have had numbers in B1 to B20, so COUNT(B:B) equals 20. Now you’ve inserted two rows with B1 and B2 now being blank or containing text and your last value pushed down to B22. But COUNT(B:B) still equals 20 because those first two cells don’t contribute – they presumably don’t contain numbers.

Yep, that method you linked to is more or less what I did. There was only one link that the Edit -> Links process didn’t work for and that turned out to be buried in a chart.

So this was all educational – I wasn’t aware you could suffer this sort of slow corruption in a spreadsheet. Had I thought about it, I would have assumed they either work as always or don’t work at all. Something to be aware of in the future.

I ended up basically copying everything to a new workbook. Had to weed out some external references the copying introduced, but it still didn’t take very long. And now the formulas work as expected. So some cruft that had accumulated from years and versions past? (It’s possible this thing is descended from a Lotus 1-2-3 version I did over 15 years ago in another office.) Don’t know for sure and I’m not going to worry about it anymore – although if anybody still has a suggestion, I’m still a little curious.

Yes, copying down to Row 50 – in the new worksheet but in the original workbook – still does give the desired result.

I’m not sure how old the workbook is – several years old at least and used in Excel 2000 when I first got into this office.

Worksheet rebuilding is not a concept I’m familiar with. Is it basically redoing the worksheet in a brand new workbook? Or something else?

That’s one I forgot to mention. I tried both Fixed (1 decimal place) and General and neither changed anything.