Opening an excel file and display all values without opening their links?

Answer It would have helped to know which version of MS-Excel you are using, and optionally what update level.As to the external links sometimes having the correct value, and other times having the "N/A#"... Read More »

Top Q&A For: Opening an excel file and display all values wi...

Can Excel VBA extract data from a file without opening it?

It should not take more than a fraction of a second to open a simple file, get a bit of data from it, and then close the file.But since you did not say what version of MS-Excel you are using, nor w... Read More »

How to Switch a Door From Right Opening to Left Opening?

A right opening door is one that, when opened, swings to the right. It is also a door that is grabbed with your right hand to open it. Doors open into the room in which you are entering. If the roo... Read More »

A customer has a counter top with a 1 ½” faucet opening. Will a faucet shank of 1 7/16” fit in that opening?

Math not your strong point? 1 1/2" or 1 8 /16" so you know tighter than (? ) but it will fit in."While I have never said this before...but I don't like a tight hole IN THIS CASE [and that is ti... Read More »

Opening a WPS File Extension?

Microsoft Works is a program that uses the WPS format. It allows the creation of documents such as letters, resumes and greeting cards. It has a clip art directory and a built-in dictionary. The pr... Read More »