No announcements
Found 13401 threads
-
4 VotesDownload for Power View Add-In For Excel 2016 Obsolete?
I just picked up a new development laptop and have run into something "odd". I'm trying to find the download for Power View for Excel 2016 and I cannot find it anywhere! ...Answered | 13 Replies | 28811 Views | Created by ansonee - Thursday, November 3, 2016 4:42 PM | Last reply by Zee_Man - Friday, August 7, 2020 10:52 PM
-
0 Votes
Excel 2016 not lock already opened file
Hello, We have a file server with Windows Server 2012 R2. All User have Office 365 Business premium and Office 2016 installed on their ...Unanswered | 10 Replies | 8954 Views | Created by Conroe997 - Thursday, March 1, 2018 7:56 PM | Last reply by derLenhard - Friday, August 7, 2020 5:01 AM -
21 Votes
PowerPivot in Excel 2016 Data Model Lost -- Empty
I am facing a most frustrating error with Excel 2016. Random loss of the data model. It happens most frequently if you open more then one instance of Excel. I make constant backups as I go ...Answered | 49 Replies | 34003 Views | Created by Casniki - Monday, October 19, 2015 2:34 AM | Last reply by spy123 - Thursday, August 6, 2020 7:06 PM -
1 Votes
How to open password protected excel files in O365(online)
Hi, I am unable to open password protected excel files in o365.Is there any solution for this.I'm trying to open in my desktop. Thanks in ...Answered | 3 Replies | 11155 Views | Created by MahenderG - Tuesday, April 19, 2016 12:53 PM | Last reply by Ken Huie - Wednesday, August 5, 2020 5:17 PM -
0 Votes
Template for income/expenditure with monthly totals
Hi there, I use an Excel spreadsheet to record finances - at the moment everything is in one long list and I have a total for the year but if I want to extract monthly income I have to cut and paste ...Answered | 10 Replies | 2131 Views | Created by Frecklepaw - Tuesday, July 21, 2020 1:00 PM | Last reply by Hans Vogelaar MVP - Wednesday, August 5, 2020 9:48 AM -
13 Votes
"Get External Data Group" greyed out
I'm having the same problem as someone else whose Excel 2010 the "Get External Data" is grayed out was also greyed out. There was a suggestion to clear the old external ...Answered | 11 Replies | 87853 Views | Created by lds37 - Sunday, May 27, 2012 12:35 PM | Last reply by J1NXXD - Monday, August 3, 2020 10:12 AM -
2 Votes
Excel password recovery
Hi, I have an employee that left on bad terms. I have an excel file that's password protected. How can I recover the password? ThanksAnswered | 18 Replies | 5117 Views | Created by kungpow112 - Thursday, November 28, 2013 7:17 PM | Last reply by Mason Tomas - Thursday, July 30, 2020 6:09 AM -
0 Votes
Pivot table field is truncated if >255 characters if pivots use connection string
I have an Excel 2013 workbook containing pivot tables. The Pivot tables get their data from a separate Excel workbook, via a connection string (Provider=Microsoft.ACE.OLEDB.12.0;, etc). If ...Proposed | 3 Replies | 2303 Views | Created by Charles1239 - Tuesday, July 21, 2020 10:57 PM | Last reply by Emi Zhang - Wednesday, July 29, 2020 9:09 AM -
17 Votes
"Errors were detected while saving (filename). Microsoft excel may be able to save the file by removing or repairing some features. To make the repairs in a new file click Continue. To cancel saving the file click Cancel.
Seems after we upgraded to Office 2016, some users are receiving this error in Excel and now also Power Point. If user opens an existing .xlsx file, makes changes, then goes to save ...Proposed | 37 Replies | 190184 Views | Created by Tech Phil - Friday, October 6, 2017 6:07 PM | Last reply by Asha Kanta Sharma - Monday, July 27, 2020 6:48 PM -
3 Votes
Conditional Formatting Formula
What I'm looking to do is, if a date had been entered into Col I, then I want the corresponding cell in Col H to have no conditional formatting (or a white cell ...Answered | 5 Replies | 1901 Views | Created by ChickLeg - Thursday, July 23, 2020 12:05 PM | Last reply by ChickLeg - Monday, July 27, 2020 1:23 PM -
0 Votes
Excel 365 problem opening file xlsx "Name Conflict Name cannot be the same as a built-in name"
Office Display Language from English to Italian and file open without any Conflict. Could you please help us to solve this issue, this is a language pack ...Proposed | 3 Replies | 17472 Views | Created by Ricky06 - Thursday, July 23, 2020 8:38 AM | Last reply by Itch Sun - Monday, July 27, 2020 9:27 AM -
0 Votes
Question about Excel 2010 and .xlk files
Tools -> General Options When i save it localy work without issues When the same file save it in a map drive in our file server THEN excel also create ...Proposed | 5 Replies | 2647 Views | Created by Vagelisr - Friday, July 10, 2020 8:31 AM | Last reply by Emily Hua - Monday, July 27, 2020 9:01 AM -
0 Votes
How to truncate column of cells with different values?
I have a column of cells that have alphanumeric computer names, the computer names are different lengths. I would like to truncate the first four characters AND the last two characters and put ...Proposed | 4 Replies | 2131 Views | Created by Filthy_Pierre - Thursday, July 23, 2020 3:46 PM | Last reply by Emily Hua - Monday, July 27, 2020 8:49 AM -
0 Votes
Getpivot data formula
Hi.. Could you please assist to make copy for GetPivot data formula for the whole column or some selected rows. The formula was ...Proposed | 2 Replies | 1966 Views | Created by Hannan81 - Friday, July 17, 2020 6:14 PM | Last reply by Emily Hua - Friday, July 24, 2020 9:54 AM -
0 Votes
Filtering in Excel without checking every possible value?
In my Excel there's data for 400 employees, but I have to report on data from 120 EmpIds. The only way I know how to do this is to check "Select Multiple Items", and then scroll and select ...Proposed | 3 Replies | 1854 Views | Created by rbhatup - Tuesday, July 14, 2020 3:27 PM | Last reply by Emi Zhang - Thursday, July 23, 2020 9:30 AM -
0 Votes
How do I change the font size in Excel 2016 PivotTable Field List?
Recently upgraded to Office365/Excel 2016. Font size in the PivotTable Field List is so amazingly small, I'll need a magnifying glass to read it. How do I increase ...Proposed | 3 Replies | 9146 Views | Created by Deborah DP - Wednesday, July 8, 2020 6:35 PM | Last reply by Emily Hua - Tuesday, July 21, 2020 1:38 AM -
0 Votes
How to combine IF-function and drop down list?
When a specific value from a drop down list i chosen, I want a new drop down list to appear in the cell next to. This second drop down should not be visible when other values are chosen, alternatively ...Proposed | 2 Replies | 2438 Views | Created by Else Mari - Thursday, July 16, 2020 11:02 AM | Last reply by Emi Zhang - Tuesday, July 21, 2020 1:29 AM -
3 Votes
Power Pivot drillthrough limited to 1000 rows
Hello, I am using Excel 2016, I made connection to an external Excel file and used Power Pivot to analyze the data. When I double clicked on one of the results, it only returned ...Proposed | 9 Replies | 37020 Views | Created by Amy Dang - Wednesday, June 6, 2018 4:55 PM | Last reply by Ryniu89 - Monday, July 20, 2020 2:25 PM -
0 Votes
Power Query not working
Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332. Used features: (none). ---> ...Proposed | 1 Replies | 2267 Views | Created by Sanjay Jamalpur - Monday, July 20, 2020 6:20 AM | Last reply by Itch Sun - Monday, July 20, 2020 7:52 AM -
0 Votes
SUMIFS, SUMIF or..
I have used SUMIFS or SUMIF to do conditional summary but this one beats me. I need to SUM Column B if Column A is Monday and so on. ...Answered | 1 Replies | 1944 Views | Created by Ian3 - Sunday, July 19, 2020 9:26 PM | Last reply by Emi Zhang - Monday, July 20, 2020 2:14 AM - Items 1 to 20 of 13401 Next ›
No announcements
