In The Wild - Gino’s East, Chicago IL
A rare event - I’ve found an issue that I couldn’t solve with a Google search - not a common occurrence, so I should get this out there and do my part to make the world a smarter place.
Problem: I am sharing an Excel 2010 spreadsheet (sample.xlsx) on Box.com, but having problems accessing it. If I try to open the file using the Box client on an iPad, I get an error: “Unable to Read Document / Unknown exception”. However, when I open the file using Excel 2010 on a PC, no worries, the file opens right up.
Root Cause: I checked out the Defined Names in the worksheet - and a large number of them had #REF errors. Basically, the tab I was looking at was probably copied from another worksheet, with other / older / extraneous tabs deleted. Any previously defined names “broke” - signified by the #REF indicators in the range values.
Solution: The problematic Defined Names were not used anywhere in the current incarnation of the sheet, so I deleted them all - and the problem went away; I could preview the file using the Box iPad client. Another solution would be to fix the Defined Names and eliminated the #REF errors.
A bit of a challenge - I have a little personal productivity “app” in Excel that shows a modeless form with some options - pick one to fill a line of data in a spreadsheet.
The challenge - I want to leave the [modeless!] form on the screen, but return focus to the spreadsheet, so I keep entering data until I need to go back to the form.
I had some trouble finding the right bit of VBA to do this - but finally did. After showing the form and copying the data to the sheet, do the following:
Cells(iRow, iCol).Select ' Select the cell you want to return to
AppActivate Application.Caption ' Return focus to the Excel sheet
Imagine a search engine that simply removed the top 1 million most popular web sites from its index. What would you discover? →
Imagine a search engine that simply removed the top 1 million most popular web sites from its index. What would you discover?
(via TechCrunch) - a brilliant way to skip past the ads and the non-value adding links that have SEO’d their way to the top.
(updated 21 Jul - more settings, more specifics)
Best settings to absolutely crush the size of a screen cast video - when all you are showing is a presentation / slides changes, with no fancy transitions - these settings really shrink things down …
When converting Live Meeting recordings …
Video Dimensions: 800 x 600
Using Handbrake for video processing …
Web Optimized: [checked]
Video Codec: H.264 (x264)
Framerate (FPS): 10
Peak Framerate: [selected]
Avg Bitrate (kbps): 20
Reference Frames: 4
Maximum B-frames: 2
A small hands-on project for me; where I work, I give Quarterly Town Hall presentations, but I know I can’t get 100% of my global staff to listen in live - so I’m recording the LiveMeeting and publishing on our SharePoint intranet.
Some FYIs about the video, and learnings for next time …
- I always tell folks to download the video to the desktop before viewing! Running a video direct from SharePoint will deliver a poor viewing experience, and bring down network performance for all of the neighbors.
- Some of my fast slide transitions don’t translate well to the shared / remote screen. They work great in person, but I may need to adjust my presentation style a bit
Tools involved in the process (it’s easy, but not incredibly easy)
- LiveMeeting records the meeting, but creates a folder full of files - difficult to “publish”
- To create a single-file “movie”, download the Recording Converter for LiveMeeting from Microsoft (free!)
- To edit the move - give it a title page and some helpful subtitles - download Movie Maker from Microsoft (also free!)
- This created a rather large file - so I downloaded Handbrake (free!)
Handbrake got the file size down a bit - I know our marketing folks use Adobe Media Encoder, but I don’t run Adobe Premier, so I don’t think I can use that.
But I’ve invested enough time into this experiment for the day, so I’ll take the savings (reinvest!), and move on to other projects. I can and will iterate on my video prep skills in the future - I’m sure we can leverage this technology for training / demonstration / explanation videos in the future! For now, time to publish and move on.
Let’s go Habs!
(Yup - one week two games two cities (two original 6!))