User Profile
Alan-Jones
Brass Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Excel Online – Refresh Power Query – Failed -- Help
I have an Excel file that I wand to be able to do a Data -> Refresh All Connections to update a very simple Power Query script. I have 4 Excel Sheets and a simple Table in each. I have a Power Query script setup to import each table them Append all 4 tables then put the Table on another sheet filtering out NULL. Unfortunately when doing a Refresh online instead of the desktop I get the error message “External Data Refresh Failed – We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh.” I only a found a few very old references to this issue and was hoping someone had a suggestion. In my mind it is not even an External connection as everything is contained in a single sheet. I know Excel desktop sometimes says it is an External connection also if not in a trusted folder. However it seems like there should be a way for this to refresh on the web if all internal to the same file. Any help thoughts or workarounds? Thanks Alan9.7KViews2likes6CommentsEncrypt Local OneDrive Files, but not in the Cloud
I have read about people interested in encrypting OneDrive files when they are stored in the in the "cloud". I have the opposite request. I want to be able to encrypt OneDrive files that are synced to my local computer, but not have them encrypted in the cloud. This way I can still use Word/Excel Online yet when they are on my local machine they are secured. I am thinking of cases where a laptop might be lost or stolen and someone may boot using other media and get access to files. For a variatery of reasons we were shying away from using the built-in full disk encryption. This would be something for Windows 7 and Windows 10. What options are out there? thanks Alan6.9KViews0likes4CommentsUpgrading from Office 2016 to Office 2016 365
We orignally had Office 2016 installed on many of our machines. Now we want to migrate from Office 2016 to Office 2016 365 so we have some of the newer features. If you do just a normal install of Office 365 will it upgrade the instlation or do we need to uninstall and reinstall? thanks Alan1.5KViews0likes1CommentOne Drive Syncing Locations Not Showing All
I have OneDrive for Business 17.3.6799.0327, besides the One Drive for Business folder sync, I also have some SharPoint (and team sites folders syncing). However I have found that the Settings -> Account -> screen only says 1 Locatin is syncing and does not show the SharPoint folders. It it my understanding that those also should show on the list if I need to stop sycncing the SharePoint folders etc. Am I missing something for how to see the other locations? thanks Alan5.4KViews0likes3CommentsOffcat?
I could not find a good group to post this to, so this seemed the most logical choice. Will we be seeing any new updates to Offcat (Microsoft Office Configuration Analyzer Tool). It seems like it is agreat tool, but it seemed to be behind some some updates. I sent in a few bug issues, but not sure it is really being updated. anyone know any back story about it? AlanS4B Stability
We run Skype For Business and 2016 (16.0.4456.1003 both 32bit and 64bit) and have a regular issues. It seems to lock up on calls on a regualrd basis if screen sharing is active. Sometimes it does not want to even make a call and inorder to get it to work you have to kill it with task manager then start it back then it is "fine". And various other odd issues. Our users that run both Skype for Business and regular skype keep reverting back to regular skype as it has been more stable. Any thoughts, tricks or knowledge a fixes coming along? Alan