Welcome to MSDN Blogs Sign in | Join | Help

New Excel Blog in Town

Gabhan Berry, a Program Manager on the Excel team, has just started up a new blog devoted to Excel programming.  To quote his first blog post:

Starting from today, I'll be blogging about all things related to programming with Excel. From addins to automation; VBA  to .NET. Oh, I'll also be posting about XLLs and coding in C/C++.

Excel programmability is a huge and very popular subject with our customers and my aim with this blog is to make it a little bit easier by sharing what I know to whomever is interested in reading.

If these topics interest you, take a look at his blog.  Feel free to suggest any Excel programming related topics you would like to see Gabhan cover in future posts.

Published Monday, February 04, 2008 2:44 PM by Joseph Chirilov
Filed under:

Comments

# Blog » Blog Archive » New Excel Blog in Town

Monday, February 04, 2008 7:54 PM by Blog » Blog Archive » New Excel Blog in Town

PingBack from http://freedombloghost.info/?p=54900

# re: New Excel Blog in Town

Thursday, February 07, 2008 12:22 PM by MG

My boss recently showed me a spreadsheet that he had taken with him from a "former life" and in this spreadsheet, under the add-ins tab on the custom toolbars section there were two drop down menus that between them displayed the names of all of the macros that were contained within. I have been asked to reproduce this functionality and so far have have not been able to figure out how to.  Any ideas as to how to do this in Excel 2007?

# re: New Excel Blog in Town

Wednesday, February 13, 2008 8:54 PM by Joseph Chirilov

Hi MG, I'm not sure if this is what you are referring to, but if you click the Office button, select Excel Options at the bottom, click the Customize tab in the window that appears, and in the "Choose commands from" dropdown select the Macros option, it will display all the macros in the active workbook.

# Some issues with 200 MB spreadsheets

Tuesday, February 19, 2008 6:20 PM by Thorsten Schmidt

Hi, i'm a heavy user of the 2007 Big Grid, my spreadsheets are 100-200MB containing high frequency stock pricing data and a large number of formulas.

Two issues I have noticed..wondering if you have advice:

1) As the spreadsheets get larger, copying down even very simple formulas (e.g. '=B3-A3') can sometimes take minutes. However, other times it works in an instant in the same type of spreadsheet. I use two different Dell Precision Workstations 390, 4GB RAM, 2 Quad Core Xeon processors on each machine. Is there any configuration to enhance performance, virtual memory settings.

2) Sometimes a set of formulas (within such a large spreadsheet) will not recalculate at all (even when reducing the number of threads to 1), and they have to be replaced to recalculate. Is this a known bug? Any fixes to it.

# re: New Excel Blog in Town

Thursday, February 21, 2008 12:42 PM by Joseph Chirilov

Hi Thorsten: if you coulld provide me with detailed steps to reproduce the two issues on our end, I will pass it along to our testers for investigation.  Thanks.

# re: New Excel Blog in Town

Sunday, February 24, 2008 2:38 PM by Thorsten Schmidt

Thanks Joseph. Since my posting I have reinstalled Office 2007 on the machine I had the #1 issue with, and the issue no longer exists (the copy-down times for simple formulas are pretty fast), so perhaps something was wrong or corrupt with the installation.

As soon as I have a case of the #2 issue again I will preserve a file of it and will write again, perhaps then you can give me an address of send the file to.

Thanks again.

# re: New Excel Blog in Town

Monday, February 25, 2008 6:50 PM by Thorsten Schmidt

Hi Joseph - me again. I have an instance of a file right now where formulas will not recalculate on one of my machines, but do on the other. Both Workstations are identical (Dell Precision 390, 4 GB RAM, 2 quad core processors each), except one has a larger hardrive (700 GB, vs 250 GB). The issue is on the machine w 700GB HD. I just reinstalled Office 2007 on it a few days ago.

The Excel file itself is 270MB, and it containts proprietary models, so I am hesitant to send. However, if you guys can do any remote diagnostics I'd be happy to make arrangements to get to the bottom of this.

New Comments to this post are disabled
 
Page view tracker