User Profile
LindaHammons
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Power Pivot - Connection Properties: Connection name [why changed and how to fix?]
I have static Excel tabs that "feed" the PowerPivot data for a particular file; nothing is external in this example (ie no SQL connections, etc.). I update this file monthly, renaming the file for the new month and copy/paste/value the new data to respective tabs, then refresh all several times. I'm now getting an error message upon refresh "The parameter is incorrect" (example attached). The problem appears to be the "Connection Properties / Connection Name" (which I've never noticed or used in the past), is pointing to an older copy of the file (example attached). Somehow the file "connections" are not changing when I rename the file for a new month. I've recently encountered this PowerPivot issue with several files (in the last month or so), and I've been using PowerPivot for years. Any guidance would be appreciated. I've included 2 screen shots below, if helpful, to see the Connection Properties and resulting error message when I try to refresh. Thank you so much!1.2KViews0likes1CommentPowerPivot accessing data tabs w/in Excel linked to other Excel files
PowerPivot accessing data tabs w/in Excel, these exist as static data within the Excel file. When I do a Save As, the link sticks to the orginal file linked to other Excel files (ie I do a Save As and the E505Views0likes0CommentsUsing Teams as a Video Conferencing tool only (vs Zoom) - link doesn't always work
I'm using Teams with a client that won't use Zoom, so I only use it to schedule a video conference with them. I schedule the meeting and "invite" them or send them the link. When it's time for the meeting, they can join but many times I can't (the link doesn't navigate me to a meeting). When I chatted with MS tech support they suggested I get an email other than gmail and directed me to this forum. Does anyone have guidance on how I can troubleshoot? Thank you so much!1.3KViews0likes0Comments
Groups
Recent Blog Articles
No content to show