Wednesday, August 17, 2011
Friday, August 12, 2011
how to fix - Excel won't show charts any more!
One day my VBA code in Excel was happily generating charts and the next it wasn't.
It would create the new worksheets, raise no errors whatsoever, but show nothing!
Nothing was changed in the spreadsheet. I even retrieved a copy from my backups.
There is no explanation I can think of for this but here is how I fixed it.
I opened the print preview dialog, went to page settings, changed the paper backwards and forwards, toggled a few other settings, left everything the way it was, closed the dialog and voila! it now works!
It would create the new worksheets, raise no errors whatsoever, but show nothing!
Nothing was changed in the spreadsheet. I even retrieved a copy from my backups.
There is no explanation I can think of for this but here is how I fixed it.
I opened the print preview dialog, went to page settings, changed the paper backwards and forwards, toggled a few other settings, left everything the way it was, closed the dialog and voila! it now works!
ps: Comments and/or links to this article are most welcome!
Subscribe to:
Posts (Atom)