Unlocking a named range: easy. Getting Excel to forget or update …
I have a spreadsheet with one worksheet, the front end, with specific ranges I want users to be able to edit. All other worksheets must not be editable by the user, but everything must be up …
Creating Custom List and using in sub site
One of my main questions is where do I pull the custom list into - is it the home page or do I have to do it on each sub site? If this is the case then that negates (I think) my next question: Is …
running simple query against MS Access database very slow
There there are 16 queries in the DB, nothing complex, minor data manipulation (convert date fields to a custom short text), grouping, and a few cross tabs. I set up some queries in Excel …
Pull data from an excel file stored in a shared onedrive account
Any help how can I do? - SharePoint does not seem to be available for consumers, and even if I still can get it, I don't think the basic version allow this type of things.
Extract Data from Word into Excel 2013
I'd like to take the information from those Word docs and import them into an Excel spreadsheet. I have seen VBA code in other forums and threads that accomplishes this to some degree. The …
Conditional formatting using named cell in Excel 2010
I think as this issue, we do not need the named range, just use the formula in conditional formatting. In my example, the range of data is listed in E18:E23, the reference value is listed …
How to disable Excel 2010 Recent Places
I am using Excel 2010 Starter Edition and Windows 7 Home Edition x64. I want no more places to be saved in Recent Places. For Recent Files there is a setting in settings where the number of …
.tmp files being created in profile - social.technet.microsoft.com
We are running Windows 7 Enterprise on all workstations and the Folder Redirection / Roaming Profiles are stored on a Server 2012 box. The problem we are seeing is there are .tmp files …