Spreadsheet Page Blog Comments

Comment on: I Think It's Finished (by Jordan Goldmeier)

Jordan Goldmeier — 2013-04-23T09:02:03-07:00

I love Wiley's new, updated artwork. I think it really fits your book, especially.

Comment on: Cloud Stats (by Jordan Goldmeier)

Jordan Goldmeier — 2013-04-23T08:34:55-07:00

Right now, Excel is receiving criticism for the sloppy work of our banking institutions and researchers, meanwhile fundamental problems that deserve our attention go virtually unnoticed. Kudos to the authors of this journal article for shedding light on these issues that greatly deserve our focus.

Comment on: Cloud Stats (by James)

James — 2013-04-19T07:02:56-07:00

http://www.nytimes.com/2013/04/19/opinion/krugman-the-excel-depression.html?hp&_r=0

Comment on: I Think It's Finished (by Kate)

Kate — 2013-04-19T03:05:11-07:00

Can't wait. Someone stole my Excel 2010 Bible while I was working a contract at a Dell office; clearly I'll never work for Dell again.
I'm not bitter.
Much.

But I'm looking very much forward to the new edition.
Congrats on release!

Comment on: No Google Stock Info (by Robert)

Robert — 2013-04-16T03:17:13-07:00

Sadly everyone has missed the point of your question, lol. Definitely intentional!

Comment on: I Think It's Finished (by Orrin White)

Orrin White — 2013-03-20T19:02:00-07:00

As usual, with me, I'm unaware that there was a "subscription route".
I'll check it out - Thanks:)

Comment on: I Think It's Finished (by John Walkenbach)

John Walkenbach — 2013-03-20T18:13:00-07:00

Orrin, Excel 2013 is fine, but only you can decide if it's worth upgrading. It's pretty cheap if you go the subscription route. If you don't like it, stop the subscription and go back to your 10-year old version.

Comment on: I Think It's Finished (by Orrin White)

Orrin White — 2013-03-20T17:50:20-07:00

Do you recommend upgrading? I'm using 2003 still because of the problem with aligning my shapes mostly (and the ribbon offends me). But I've got a gig imminent and the client is using 2010. I've only had a couple of issues with my converter for hundreds of posted solutions on the Excel Forum. In contrast to you - I've only sold six books in a year and I bought your 2003 Power Programming. I post as XLAdept.

Comment on: I Think It's Finished (by John Walkenbach)

John Walkenbach — 2013-03-18T14:38:49-07:00

Excel 2010 Bible would be a better choice, unless you're planning to upgrade to Excel 2013.

Comment on: I Think It's Finished (by Tom)

Tom — 2013-03-18T14:20:07-07:00

I currently have 2010 installed would the 2013 bible be my best choice?

Comment on: New Tip Posted (by John Walkenbach)

John Walkenbach — 2013-03-14T10:41:51-07:00

Maybe check your Trust Center settings? That, of course, is a confusing mess, so it could be anything.

Comment on: New Tip Posted (by Doug jenkins)

Doug jenkins — 2013-03-14T03:26:02-07:00

Thanks John, that's great (I only need to think of an engineering angle and I'll have a NewtonExcelBach topic all in one).

But

When I run it, it skips the first security message, but I still get the "blah, blah, blah, would you like to open this file?" message.

Any suggestions?

Comment on: Posted: Light Box Demo (by Viggen)

Viggen — 2013-03-03T15:11:09-07:00

This XL file crashes my Office 2010, on a Windows XP machine

Comment on: Excel's VBA Undo Problem (by TaeWong)

TaeWong — 2013-03-01T07:40:48-07:00

If you change the undo buffer history to 20, 30 or something on an older version such as XP, Excel XP will limit the undo buffer to 16 actions. Code on the Excel Forum displays Please Login or Register to view this content.

Comment on: A Functional IMAGINARY Tale (by Jordan Goldmeier)

Jordan Goldmeier — 2013-02-25T17:14:57-07:00

Seems like a slippery SLOPE

Comment on: No Google Stock Info (by Allen Cody)

Allen Cody — 2013-02-25T15:00:00-07:00

This is typical Microsoft. By using this method, parameters for the External Data Range inserted next to the stock symbol cannot be edited, although you can still control the refresh rate. I prefer to use the Data\Existing Connections\MSN MoneyCentral Investor Stock Quotes method to pull in a data range that allows you to assign the value for refresh to the cell that contains the stock symbol, e.g., GOOG, and allow the range to be updated when the value changes, e.g., to AAPL for example.

I believe MS allows up to 150 symbols using this method whereas Yahoo!Finance allows up to 200 symbols to be pulled into a worksheet. I found a cool VBA procedure on the Internet that works well for this purpose. Happy to share (will credit the original source) if John approves.

Comment on: A Functional IMAGINARY Tale (by Winston Snyder)

Winston Snyder — 2013-02-24T11:03:33-07:00

We have the POWER to ROUNDUP all of the functions in Excel to CHOOSE from a COMPLEX list of VALUEs to FIND the EXACT MATCH that will YIELD the PROPER results we are looking for.

Comment on: Joe's A Fan (by Dave)

Dave — 2013-02-22T09:05:29-07:00

I've been writing craps simulators since the days of GW basic. It really lends itself to object oriented programming making use of VBA class modules. You can email me if you're interested in hearing more.

Comment on: No Google Stock Info (by chip`)

chip` — 2013-02-22T08:04:36-07:00

GOOG stock is in beta and is only payable in Monopoly money, hence the listings are not real. When GOOG stock becomes a live program, a cupcake party will be held for all "shareholders" and they will have an opportunity to buy actual shares.

Comment on: No Google Stock Info (by Bob Bridges)

Bob Bridges — 2013-02-22T04:17:46-07:00

Thanks John,
Stock prices seem to only work for US stocks.
Non of my UK stocks work.

Comment on: A Functional IMAGINARY Tale (by Jordan Goldmeier)

Jordan Goldmeier — 2013-02-21T14:47:58-07:00

Is this a new TREND?

Comment on: A Functional IMAGINARY Tale (by Doug Glancy)

Doug Glancy — 2013-02-21T11:40:48-07:00

If you expand this it could be a BESSELIng novel with your picture on the COVAR!

Comment on: No Google Stock Info (by John Walkenbach)

John Walkenbach — 2013-02-21T10:18:28-07:00

Bring up the Excel Options dialog box, Proofing tab. Click AutoCorrect Options. In the AutoCorrect dialog box, click the Actions tab and choose 'Enable additional actions' in the right-click menu.

Comment on: No Google Stock Info (by Bob@Bricomp-uk.com)

Bob@Bricomp-uk.com — 2013-02-21T10:03:24-07:00

Sorry should have been "....Actions"

Comment on: No Google Stock Info (by Bob Bridges)

Bob Bridges — 2013-02-21T10:02:05-07:00

How do you get "Additional Cell Options" to appear? My drop down list stops at Hyperlink.
I'm using Office64 2013 on Win8 64.

Comment on: Dynamic Range Names? (by John Walkenbach)

John Walkenbach — 2013-02-20T16:09:14-07:00

I had occasion to use one today to generate a variable-length array for use as the last argument for the SERIESSUM function.

Comment on: Dynamic Range Names? (by ross)

ross — 2013-02-20T15:40:04-07:00

Hi John,

Yes, I still use them, if you are addressing a fixed range of formulas, (of which you area extracting only some of the data...) then I don't think a table would work(may be quite a specific case!). Likewise if I'm deleting and refreshing a data set, I tend to find it easier to work with DNR, but this might just be my habit, so to speak...

Comment on: A Functional IMAGINARY Tale (by John Walkenbach)

John Walkenbach — 2013-02-20T14:42:58-07:00

You're RIGHT. It was TRUNCATEd. NOW it's FIXED. It only took a MINUTE to paste the ending.

Comment on: A Functional IMAGINARY Tale (by Mike Alexander)

Mike Alexander — 2013-02-20T14:31:48-07:00

DCOUNT of times I hit the FLOOR reading this is LARGE.

Comment on: A Functional IMAGINARY Tale (by Toad)

Toad — 2013-02-20T11:51:48-07:00

Your story appears TRUNCATEd.

Comment on: Excel Cat (by Akbar)

Akbar — 2013-02-20T06:25:34-07:00

Rating This is a great book. I use it almost evedyray. It is super useful and you can use it as an evedyray office reference book. I was a bit concerned when I decided to purchase the book but it really met and surpassed all my expectations. If your interested in using excel for both personal and professional use this is book that puts you one step closer to mastering excel.

Comment on: A Functional IMAGINARY Tale (by miho66)

miho66 — 2013-02-20T01:25:36-07:00

It's an EXCELlent tale I ever VIEWed.

Comment on: A Functional IMAGINARY Tale (by Ray)

Ray — 2013-02-19T16:30:17-07:00

Did you post too soon?

What happens after the FORECAST?

Comment on: PUP Compatibility With Excel 2013 (by John Walkenbach)

John Walkenbach — 2013-02-19T10:35:40-07:00

Sorry Jack, that's not exactly a common need.

Comment on: PUP Compatibility With Excel 2013 (by Jack O'Sullivan)

Jack O'Sullivan — 2013-02-19T10:18:57-07:00

Is there any way you could sneak in the ability to include a Paste Special that Reverses the selection before Pasting? I.e., paste the bottom cell at the top, the right cell at the left, and string the remaining ones in reverse order?

Thanks for all you do and have done!

Comment on: PUP Compatibility With Excel 2013 (by John Walkenbach)

John Walkenbach — 2013-02-19T07:56:59-07:00

It will probably be the normal $5 upgrade fee, and the VBA password will be the same as PUP v7.

By the way, this upgrade is not going well at all. The single-document interface in Excel 2013 is causing major headaches. I think a few of the utilities will have reduced functionality -- for example, no "toolbar" in the Worksheet Map utility.

Comment on: PUP Compatibility With Excel 2013 (by Caula)

Caula — 2013-02-19T03:05:00-07:00

Is the PUP update for Excel 2013 going to be free for existing licensed PUP users?

Comment on: 30 Years Of 1-2-3 (by Guy)

Guy — 2013-02-18T06:12:34-07:00

Using Lotus 1-2-3 was my introduction to using a computer, instead of playing games on one.

Comment on: 30 Years Of 1-2-3 (by pagezone)

pagezone — 2013-02-17T12:56:04-07:00

Yes, I remember the great time with Lotus Notes. And now there is just a museum.

Comment on: PUP Compatibility With Excel 2013 (by John Walkenbach)

John Walkenbach — 2013-02-11T20:22:29-07:00

No. That version doesn't support macros or add-ins.

Comment on: PUP Compatibility With Excel 2013 (by Michael Davis Consultant)

Michael Davis Consultant — 2013-02-11T19:50:43-07:00

Great,

Will this also work on Microsoft office 360, the cloud based version of EXCEL?

Comment on: Dynamic Range Names? (by Allen Cody)

Allen Cody — 2013-02-10T10:13:12-07:00

I haven't read every blog note but Ken's recent blog, Feb 7, makes me suggest a similar method to create a dynamic range without VBA. Using Ken's data, the data is on worksheet "Data3". The data range is in column A. Cell A1 has a header.
Go to name manager, and create a named range for the data in column A. Call it "MyRange" or whatever. Put the following formula in the "Refers To" area when creating the named range:
=OFFSET(Data3!$A$2,0,0,COUNTA(Data3!,$A:$A)-1)
The formula assumes you have a header in cell A1, so you start at cell $A$2 - lock this in place.

I tested this for data in an Excel Table, and it works fine. Each time you add or delete a record in the table, the range adjusts correctly.

Comment on: Dynamic Range Names? (by Ken Clifton)

Ken Clifton — 2013-02-07T21:37:16-07:00

I have used the following for years. Say your data is on a sheet called Data3.

I use the first one for my Validation List, and the 2nd for the Lookup Range, etc.

=INDIRECT("Data3!$A2:A"&COUNTA;(Data3!$A:$A))
=INDIRECT("Data3!$A2:B"&COUNTA;(Data3!$A:$A))

Comment on: I Think It's Finished (by Ken Clifton)

Ken Clifton — 2013-02-07T21:26:26-07:00

John,

Over the years I have purchased nine of your books. I went ahead and per-ordered two more. My thinking is I might learn something, but more importantly, I plan on giving them away as gifts so someone else may benefit from your vast knowledge.

I agree that the printed book is not as popular as it once was, but I for one get so much more from reading the printed book vs an electronic copy, maybe it's because it's my age.

The reason I like the printed book is it's easier on my eyes, I can curl up and read it where I want (yes I know they have Kindles and such), but it's just not the same.

So now the 64K question, what do you think about Excel 2013 (in depth)? Personally I think it's the best Excel yet. I hated 2007, but 2010 was much improved, and I can see a lot of good things in 2013.

Enough - Already.

Bottom line. - Congratulations on the new books. I wish you the best of luck and know the sales will be impressive.

Comment on: 30 Years Of 1-2-3 (by Ken Clifton)

Ken Clifton — 2013-02-07T20:38:55-07:00

I cut my teeth on 1-2-3. I remember when they finally went to version 2.4 that had WYSIWYG. I loved it. Before that I had the IMPRESS add in, and everyone would ask how did you get your documents to look like that?

Before WYSIWYG you would have to use additional cells to make lines to separate the values.

My last version of 1-2-3 was the WK4 format, I think it was version 5.0. You could make nice menus (like Excel), and it was great, but alas Excel over took it and I switched around 1995-1996 and never looked back.

One thing that 1-2-3 beat Excel on was the Solver, 1-2-3 (version 5+) allowed more variables than what Excel did.

Comment on: PUP Compatibility With Excel 2013 (by Ken Clifton)

Ken Clifton — 2013-02-07T20:30:52-07:00

I hate the ALL CAPS, in 2013. I already renamed them (except for FILE and ADD-IN.

I noticed that Toggle Settings gets a Run Time error, glad you will be making an update.

Thanks John!

Comment on: PUP Compatibility With Excel 2013 (by Andrew Macaulay)

Andrew Macaulay — 2013-02-05T08:45:52-07:00

Excellent news. Are you also going to make the main tab menu on 2013 all caps (to be consistent with new menu styles - maybe simply making it "PUP"

Comment on: Dynamic Range Names? (by kashmarek)

kashmarek — 2013-02-05T07:03:58-07:00

I have expanded charts by simply inserting rows, and then pasting the data into the range of the chart (or graph). Usually, I make the last row of data a blank row to insert new blank rows above it for the new data. If the last row can't be blank, then insert rows above the last row, copy that row to the first inserted blank row, and then paste data over the last row.

Comment on: Excel 2013: Finalized (by Franco)

Franco — 2013-02-04T07:10:46-07:00

Does PUP v7 work with 2013?

Comment on: 30 Years Of 1-2-3 (by Doug jenkins)

Doug jenkins — 2013-02-01T17:34:14-07:00

Good to read someone being so generous about a competing product.

I wonder how many people in the world still use 123 (I do).

Comment on: How Fast Is Your System? (by Don Ford)

Don Ford — 2013-02-01T14:25:49-07:00

3.277344 Sec

Excel 2007
I5 2500K @ 3.30Ghz
8 GB Corsair DDR3 Ram
1-TB SATA HD

Comment on: Excel 2010 vs 2013 Speed Benchmark (by Steve Farrar)

Steve Farrar — 2013-01-25T07:26:27-07:00

I have some macros that run at about the same speed but I have at least 2 where it takes way too long to run- fortunately I did not remove Excel 2010 so I can run them using that --but Microsoft needs to fix this!!!

Comment on: I Made A Simple Task Pane App (by jon)

jon — 2013-01-23T12:46:01-07:00

I was watching the Microsoft Build Conference and they were saying that the apps ability is limited right now but in the future they plan to make it better. Don't know if it will ever be as great as add-ins though.

It would be interesting to know how to make a program that builds on top of the apps so you don't have to build the program more than once that is backwards compatible to previous Excel programs. It's on my list of things to look at, but haven't had time yet.

Comment on: I Made A Simple Task Pane App (by John Walkenbach)

John Walkenbach — 2013-01-22T14:10:50-07:00

No, I've decided that I have no interest at all in creating Apps for Office. At least at this point. It's just too limited.

And besides the feature just stopped working for me. Every app I try gives a bogus "unsupported browser" error.

Comment on: I Made A Simple Task Pane App (by Rick)

Rick — 2013-01-22T13:39:54-07:00

I'm teaching VBA and have learned a lot from your books, and looking at supporting Office 2013 (so, I'll probably by your book because those PED guys are a bit behind the times), but wondering... do you think you'll be adding JavaScript/HTML to your books sometime? Your last comment was in August and when I looked at the Preview in December, it had some interesting sample apps from the App store. Any thoughts now?

A part of me wonders if this the future where, looking down the road a version or two, we don't see VBA in Office. But you are right, they could just abandon the Javascript thing.

Comment on: Enhanced Data Form Crashing? (by Ramsey Prescott)

Ramsey Prescott — 2013-01-19T23:22:57-07:00

Please help with Excel 2010 64-bit excel. The criteria does not work, Thanks.

Comment on: Dynamic Range Names? (by Thomas)

Thomas — 2013-01-16T13:23:27-07:00

Range names are important if you are using Tables as you mentioned. If you use a reference like Table[column] in a formula, it changes as you auto-fill the formula. The only way to make it an absolute reference is to use a range name.

Comment on: Excel 2010 vs 2013 Speed Benchmark (by Jim Cone)

Jim Cone — 2013-01-15T23:17:46-07:00

For what it is worth...

Excel 2003 score: 74.84
Excel 2010 score: 64.24

Memory: 3.49 GB
Windows XP, Intel Pentium Xeon @ 3199

Comment on: How Fast Is Your System? (by Arkohn)

Arkohn — 2012-12-29T20:24:00-07:00

3.999018 Seconds - 1st run

Excel 2010 32 Bit
i7-3770 @ 3.4 Ghz
16 GB DDR3 Ram
Corsair GT 240GB SSD

Comment on: Announcing: PUP/Mac (by lindalva)

lindalva — 2012-12-22T17:22:00-07:00

Good day,
what a claver man? HAPPY ENDINGS!
kind regards.

Comment on: I Made A Simple Task Pane App (by Jon)

Jon — 2012-12-15T12:03:44-07:00

From reading the App blog it sounds like this is just the beginning for the functionality of the apps. After reading more about it I'm pretty excited. I developed a time card add-in that could be extended to apps and that way it could actually be used when you are away from your computer (unless you are like me and don't have a smart phone nor tablet).

First things first though. Learn [removed]/

Comment on: Twelves (by Dick Kusleika)

Dick Kusleika — 2012-12-14T06:36:20-07:00

That formula doesn't work for me. It's returning a different number. Please fix this bug in Excel.

Comment on: Twelves (by Squiggler)

Squiggler — 2012-12-14T01:07:58-07:00

I was just going to say, perhaps Excel 2007 would be more appropriate!

Comment on: Twelves (by Seb)

Seb — 2012-12-13T12:42:05-07:00

Not in Excel 12 though

Comment on: Twelves (by Matt S.)

Matt S. — 2012-12-13T04:01:41-07:00

Just need 12 comments now............

Comment on: Posted: Unlinking A Pivot Table (by Nathan B.)

Nathan B. — 2012-12-07T10:02:02-07:00

Is the a way to replicate the second paste process from the clip board in VBA code? I tried performing the steps with the macro recorder on but that returns a "Paste method of worksheet class failed" error when run independently.

Comment on: Another PUP Sale (by Al Broussard)

Al Broussard — 2012-11-28T14:08:06-07:00

John

I miised the PUP sale by one day, will there be another?

Thanks

I wrote to you awhile back from my work email (abrouss@entergy.com)about mp3 lister, I still use newer version you sent me (filelister).
Thanks
Al

Comment on: Excel 2010 vs 2013 Speed Benchmark (by Erik Westwig)

Erik Westwig — 2012-11-20T12:14:47-07:00

I did a test with recalcing a single Rand function a zillion times, and I found 2013 to be half as fast as 2010 on the same (Windows 7 machine).

Comment on: Office 2013 RIBBON TABS (by Barry Fitzgerald)

Barry Fitzgerald — 2012-11-14T06:48:41-07:00

Doesn't appear to be a way to change FILE??

Comment on: Office 2013 RIBBON TABS (by Rick Rothstein)

Rick Rothstein — 2012-11-11T20:27:00-07:00

@John,

On XL2007 (don't have XL2010 so I don't know about it), when you press the ALT key, the shortcut letters appear (H over the Home tab, N over the Insert tab, etc.). So, if you rename Home to, say, Domicile and then press the ALT key, an H will still appear for it? I guess I understand why Microsoft would want to keep the same shortcuts, but it seem like renaming tabs without being able to give them meaningful shortcuts might end up making things confusing down the line.

Comment on: Office 2013 RIBBON TABS (by John Walkenbach)

John Walkenbach — 2012-11-11T14:04:15-07:00

The Alt keyboard shortcuts don't change is you change the ribbon tab text. The keyboard shortcuts are built-in and (I think) cannot be changed. That ampersand thing doesn't work with the ribbon.

Comment on: Office 2013 RIBBON TABS (by Rick Rothstein)

Rick Rothstein — 2012-11-11T13:46:22-07:00

I have not loaded XL2013 yet, but will when I get my new computer in a few weeks. Microsoft giving each user the ability to be able to change the tab names completely seems surprising to me. I presume ALT+ keyboard shortcuts still exist in XL2013... what happens to the default shortcuts when you change the tab names? Do they stay the same or do you get to create new shortcuts using the old trick of preceding the new shortcut letter with an ampersand character?

Comment on: Office 2013 RIBBON TABS (by Doug Glancy)

Doug Glancy — 2012-11-08T10:05:39-07:00

I wonder if it will stay lower case if you change it to "Homer" and then back to "Home." I've seen this behavior elsewhere in the Microsoft world, although can't remember where.

Comment on: Excel 2010 vs 2013 Speed Benchmark (by John Walkenbach)

John Walkenbach — 2012-11-07T17:06:53-07:00

I haven't taken the time to learn about this benchmark, but a higher score is better. If somebody notices some significantly slower macro performance, I'd be interested to hear about it.

Comment on: Posted: Light Box Demo (by John Walkenbach)

John Walkenbach — 2012-11-05T19:07:17-07:00

It took nearly three years but Ken got an answer.

Comment on: I Think It's Finished (by John Walkenbach)

John Walkenbach — 2012-11-05T19:04:30-07:00

It's my bestselling book (by far) so I spent a lot of time making it cleaner and more polished. I also think it's a bit more comprehensive. I also eliminated a lot of filler and replaced it with more useful stuff.

For some reason, I just spent a lot more time getting this one as near perfect as a computer book can get. I've never spent so much time working on the minor details. But when I hold it my hand, I'm sure I'll find dozens of errors. That's how it always goes.

It's very possible that the concept of actual printed books is coming to an end. If that's true, I'd like to go out with a good one.

Comment on: I Think It's Finished (by Doug Glancy)

Doug Glancy — 2012-11-05T12:27:48-07:00

Congrats. What will make this the best ever, besides the fact that you have some experience writing these now?

Comment on: Excel 2010 vs 2013 Speed Benchmark (by Butch Barker)

Butch Barker — 2012-11-04T05:20:07-07:00

I don't understand, it seems to me that it shows 2013 as being slower

Comment on: Excel 2013: Finalized (by John Walkenbach)

John Walkenbach — 2012-11-03T16:24:37-07:00

Yes, Light Gray is very similar to the old Silver theme.

Comment on: Excel 2013: Finalized (by John Walkenbach)

John Walkenbach — 2012-11-03T16:20:57-07:00

RE: task pane. Press F6, and all of a sudden it's keyboard accessible.

Comment on: Posted: Light Box Demo (by Oscar)

Oscar — 2012-11-03T05:53:44-07:00

Ken,

'ThunderDFrame' is the classname of userforms made by Excel.

Comment on: Excel 2013: Finalized (by sam)

sam — 2012-11-03T03:56:59-07:00

Thank God for the Light Gray theme - Does this match with the Silver look of the earlier 2 versions

Comment on: Excel 2013: Finalized (by Viggen)

Viggen — 2012-11-02T19:47:40-07:00

If you try to experiment your previous macros, you will find that they will take longer to run

Comment on: Excel 2013: Finalized (by John Walkenbach)

John Walkenbach — 2012-10-27T06:14:56-07:00

That statement is very misleading. The Apps for Office are able to interact with Excel in a very limited way. It's no substitute for VBA. Note even close.

Comment on: Excel 2013: Finalized (by Doug Jenkins)

Doug Jenkins — 2012-10-26T21:40:25-07:00

I haven't been following Office 2013 at all, but I was interested in this comment on the MS Office site:

Office 2013 is about integrating the web with Office applications that are already familiar to users. This shifts the development focus from a proprietary language (Microsoft Visual Basic for Applications) to web-based languages (HTML, CSS, JavaScript, etc.) that enable you to use your web development skills for Office development.

So does this mean Javascript is the way of the future?

Will Excel based web applications with active javascript code be possible with Excel 2013?

Comment on: New Units For the CONVERT Function (by Doug Jenkins)

Doug Jenkins — 2012-10-21T00:50:45-07:00

OK, I suppose 42 new units is better than nothing, but it's still pretty weak. Nothing for torque, second moment of area (length ^4), flow rate, fuel consumption, no kips or poundals. That's just off the top of my head.

You can fix that with the help of Wikipedia and a bit of VBA though.

http://newtonexcelbach.wordpress.com/2012/10/11/daily-download-24-units-for-excel/

Units4Excel download (free and open source):
http://www.interactiveds.com.au/software/Units4Excel.zip

Comment on: Dynamic Range Names? (by chuck)

chuck — 2012-10-20T07:40:13-07:00

I use your offset trick all the time in dyn name ranges becuase I can't figure out how to convert a multidemensional array into a table.

Comment on: How Fast Is Your System? (by H2ouup2)

H2ouup2 — 2012-10-19T20:42:34-07:00

4.632813 Sec

Excel 2010
W7U 64b
10 GB Ram
i5 @ 3.0GHz
Excel 2010 32b

Comment on: Dynamic Range Names? (by Jordan G)

Jordan G — 2012-10-18T17:38:37-07:00

I've found applying a custom format to tables seems to make Excel act unpredictably. This really hasn't made me a huge fan of them.

Comment on: Dynamic Range Names? (by Yard)

Yard — 2012-10-18T06:35:54-07:00

I still use them because of the flaws in the Table functionality - namely the crunching and grinding that happens if you try to add or delete multiple rows or if you paste a set of values into a table, thereby extending it, where those values were copied from a non-contiguous range.

You also can't refer to table ranges in other (closed) workbooks - admittedly you can't do this with dynamic ranges either, but it just added to my dissatisfaction with Tables.

Maybe they've fixed some of this in Excel 2013?

Comment on: Dynamic Range Names? (by OmarF)

OmarF — 2012-10-17T19:50:50-07:00

@Oscar Cronquist

I rarely put data validation lists on the same tab as the validated cells so I never tested whether data validation would take a table column as a source in that case.

When I create a Range Name using Name Manager, I add something like this to the source box (assuming I already have a table set up):

=Table1[Column1]

Comment on: New Units For the CONVERT Function (by John Walkenbach)

John Walkenbach — 2012-10-17T17:48:31-07:00

Typo fixed.

When will we have an intelligent spell checker?

Comment on: New Units For the CONVERT Function (by Ron)

Ron — 2012-10-17T17:12:15-07:00

The CONCERT function?

Does that show when your favourite artist is playing in your area?

LOL

Ron

Comment on: Elevens (by James Miles)

James Miles — 2012-10-17T06:32:52-07:00

I'm using excel 2007, I have changed my colour scheme to black and the trim of the window is black and the menu bar/toolbars are black. What the other guy was asking is how have you changed the column headers (A, B, C) and the Rows (1, 2, 3) to be black as mine are still a silvery colour when yours are clearly very dark

Thanks

Comment on: How Fast Is Your System? (by Phoenix599)

Phoenix599 — 2012-10-16T14:26:19-07:00

4.515625 sec

W7U 64b
16GB RAM
i7-2600K @ 3.40GHz
Excel 2010 32b

Running iE 9, Outlook 2010, iTunes, and several other programs in the background...

Comment on: How Fast Is Your System? (by Coffee)

Coffee — 2012-10-16T11:39:45-07:00

14.48 sec on Excel 2011 for Mac OS X...

Machine: iMac 2010
Processor: Intel(R) Core(TM) i5-CPU @ 3.60GHz
OS: Mac OS X 10.7.5
RAM: 16 GB
Excel 2011 (32 bits)

Comment on: How Fast Is Your System? (by Coffee)

Coffee — 2012-10-15T17:11:21-07:00

Error: last post Coffee says i5 @ 3.6 GHtz, it's 2.5 GHtz
Also, Virtual machine has 4 GB of RAM, not 8

Comment on: How Fast Is Your System? (by Coffee)

Coffee — 2012-10-15T17:09:23-07:00

4.42 seconds
Machine: Virtual machine (VMware Fusion 4.1.3) - iMac 2011
Processor: Intel(R) Core(TM) i5-CPU @ 3.60GHz
OS: Windows XP Pro 32 bits
RAM: 8GB
Excel 2010 32 bits: 4.42 seconds

Comment on: Dynamic Range Names? (by Doug Glancy)

Doug Glancy — 2012-10-15T13:09:31-07:00

I've never noticed them slowing down a workbook, but trying to add thousands of rows in code has brought things to a grinding halt for me.

Comment on: Dynamic Range Names? (by JonC)

JonC — 2012-10-15T12:53:31-07:00

Is it me or tables (listobjects) slow down the workbook ?