It is the year 2008, we are half way through. Excel 2003 is 5 years old. Stop using it please.
Why? Excel 2003 has the old “limits” - 65,000 rows, 256 columns, memory limits etc. Excel 2007 on the other hand, 1 million row limit, etc etc. That coupled with the way pivot tables work [...]
Leave a Comment | 204 views
I have ran across this a couple times now, I actually had a blog post draft written up for this but never got around to finishing it, well this week I ran into the issue again, so here it is.
Importing data from Excel (using whatever - C#, VB.NET, SSIS, Access, etc) - you have data [...]
Leave a Comment | 287 views
Earlier I blogged about exporting SSRS (SQL Server Reporting Services) Reports to Excel and keeping formatting. Well, my previous solution works, but not always (doh!)
I found in a new report that I created that the formatting was taking on all columns. The solution? Wrap those expressions in CDec() function and it works. It was for [...]
Comments (5) | 366 views
When creating Reporting Services (SSRS) reports, I usually use FormatCurrency() and FormatPercent() around values to make the report look good. Today I found out that when you use those, and export to Excel, you lose the ability to sum the values, because everything is exported as text.
The right way (or at least the way that [...]
Comments (3) | 1,340 views
