Daily posts of Excel tips…and other stuff
Archive for the ‘Bugs’ Category.
When I save my Excel workbook as a webpage, my hidden columns are no longer hidden when viewed in Firefox. It seems to be OK in IE6.
I unhid the columns, turned the font white, made the columns thin, and it seems fine.
I know some of you are against white-font-on-white-fill hiding, but I think [...]
This report comes from Charles Williams of DecisionModels.com fame. Charles knows a thing or two about performance in Excel.
For the last few weeks I have been trying to find out why clearing a large range of cells caused Excel to hang on some PCs but not on others. This does not happen with Excel [...]
Dave Gainer writes:
Two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download from the following locations:
Via Slashdot:
It seems that any formula that should evaluate to 65,535 will act strangely.
Slashdot article references this newsgroup post.
I'm trying to run this code:
Set wbStan = Workbooks.Add(gsTemplateFldr & gsSTANFLDR & gsSTAN)
and gsSTAN is a global constant set to 'Standards.xls'. I forgot to create the folder gsTANDFLDR and, of course, the file is not in there either. I get this error message:
The third bullet point is what strikes me as strange. [...]
Hi all
For the users of a non English version of Excel 2007 maybe this information is useful.
http://www.rondebruin.nl/atp.htm
Have a nice day
Ron de Bruin
http://www.rondebruin.nl/tips.htm
As many of the frequenters of this great place will know, Charles Williams and I created The Excel Name Manager. The # 1 (FREE) tool on the web to work with defined names in Excel.
Well, we do occasionally get feedback on this tool (which is always appreciated!) and in all these years, we got two [...]
Why does this:
Sub CharCounts()
Dim i As Long
With ActiveCell
Debug.Print .Characters.Text, .Characters.Count
For i = 1 To .Characters.Count
Debug.Print .Characters(i, 1).Caption, .Characters(i, 1).Count
Next i
End With
End [...]
