-
Archives
- April 2018
- March 2018
- February 2018
- January 2018
- November 2017
- September 2017
- June 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- February 2015
- August 2014
- July 2014
- May 2014
- April 2014
- February 2014
- January 2014
- December 2013
- October 2013
- September 2013
- August 2013
- October 2012
- December 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
-
Meta
Monthly Archives: December 2010
Is Excel 2010 Kinda Fragile ?
I have once again run into a major probem in Excel 2010 related to doing major surgery on a large file and ending up with it being unwilling to Save and requiring me to perform some serious “sleight-of-hand” to save … Continue reading
Posted in Uncategorized
Tagged Excel, Microsoft Excel 2010, Office 2010, Office Development, VBA
4 Comments
I Didn’t Follow My Own Rules
I am currently involved deeply in a project that replaces an exisiting spreadsheet-based production-planning system. The existing user-maintained document is one of the most dangerous spreadsheets I have ever seen. But when contacted to help on this I made a terrible … Continue reading
Errata2
I have always worried about giving code advice here for the simple reason that I might be misleading people with wrong, or inefficeient code or code that I thought worked in all conditions but subsequently could be proven otherwise. Well … Continue reading
Posted in Uncategorized
Tagged Excel 2010, Microsoft Excel, Microsoft Excel 2010, VBA
Leave a comment
Putting Tables To Work In Excel 2010 – Errata
A week or so ago I included some code in a Blog about using Tables in Excel 2010. In that blog I included some code that, among other stuff, was supposed to clear all the existing rows of data in … Continue reading
I Think I’m In Switzerland
Here’s a picture JUST taken out our bedroom window: So beautiful !! 60+ cms in the last two days with more to come (and then rain on Friday darn it 😦 ) So we have School Snow Days and extra … Continue reading
Posted in Uncategorized
Tagged DAX, Excel 2010, Microsoft Excel 2010, PowerPivot, Structured References
5 Comments
Observations On A New Bathroom
We had a flood in my house when I was in Europe last month.. Apparently the toilet overflowed in the upstairs bathroom when my grown son was here alone (apparently :-)) and it destroyed the upstairs bathroom, the hall (which … Continue reading
Posted in Uncategorized
Tagged Access 2010, Consulting, Excel 2010, Microsoft Access 2010, Microsoft Excel 2010, Office Development, VBA
Leave a comment