No announcements
-
0 VotesPowerpivot 2012 invalid user name and password
Does anyone know how to resolve the error message "User name or password is invalid" for PowerPivot 2012? The same user name and password for the machine DOES work on ...Unanswered | 5 Replies | 37 Views | Created by IT_BMC_Lady - 3 hours 58 minutes ago | Last reply by IT_BMC_Lady - 46 minutes ago
-
0 Votes
Files in Document Recovery when AutoRecover is turned Off
We have unchecked the "Save AutoRecover information every X minutes" option in Excel 2016. In the registry we also have the following set to ...Proposed | 2 Replies | 45 Views | Created by sajad-deyargaroo - Wednesday, October 16, 2019 2:01 PM | Last reply by sajad-deyargaroo - 3 hours 47 minutes ago -
0 Votes
Formula tooltip covers column names
Hi, I sometimes write very long Excel formulas. I like to troubleshoot them by clicking on the name of the formula and seeing which cells are involved. But when I ... -
5 Votes
Excel - worksheet freeze and high cpu usage
Hi. I have Office 365 installed and sometimes worksheets and ribbon get freezed. The weird thing is that workbook works, because I can close it. When it happens the Excel process makes a huge cpu ...Answered | 23 Replies | 29911 Views | Created by Cartovi - Tuesday, July 12, 2016 10:58 AM | Last reply by Jackie518 - 5 hours 37 minutes ago -
4 Votes
ListControl alternative to make it work in VBA7 64 bit Excel add-in
We have 32 bit excel add-in written in VBA6. To provide 64 bit excel add-in we are migrating code to VBA7. We used VB6 ListControl in lots of places. As ofiice is not shipping 64 bit MSCOMCTRL or ...Proposed | 10 Replies | 25219 Views | Created by Mahesh.Bakshi - Friday, September 17, 2010 6:58 AM | Last reply by yamashiro akihito - 6 hours 15 minutes ago -
0 Votes
Data Validation Error in excel file
Hi All, I am getting following error when adding Data validation to cell : "The list source must be a delimited list or a reference to a single row ...Proposed | 7 Replies | 44029 Views | Created by Manojsingh Rajput - Monday, February 6, 2012 6:41 AM | Last reply by AnnieC06 - 7 hours 33 minutes ago -
0 Votes
-
0 Votes
How to prevent table from growing in size, but allows for new rows
I have a sheet that has a specified number of rows I can show for a table. I'd like to be able to lock the tables size so it doesn't grow on screen, but still allows new rows to be ...Unanswered | 1 Replies | 36 Views | Created by Tracy McClain - Thursday, October 17, 2019 1:09 PM | Last reply by Emi Zhang - 12 hours 25 minutes ago -
0 Votes
I can open personal.xlsb on one computer, but not another: 'Excel cannot open the file personal.xlsb because the file format or file extension is not valid.'
Excel cannot open the file personal.xlsb because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of ...Unanswered | 3 Replies | 42 Views | Created by cagross99 - Thursday, October 17, 2019 9:04 AM | Last reply by Emi Zhang - 12 hours 57 minutes ago -
0 Votes
SUMIFS?
Can I achieve multiple conditions with a formula of SUMIFS? =SUMIFS($L$2:$L$302501,$A$2:$A$302501,"<>3"...?) Please help! ...Unanswered | 1 Replies | 21 Views | Created by Domin2018 - 15 hours 9 minutes ago | Last reply by Hans Vogelaar MVP - 14 hours 53 minutes ago -
4 Votes
Powerpivot data import hangs excel 2016
When attempting to import an Excel file into PowerPivot, Excel 2016 hangs. Here are the steps I use: Open Excel, Blank workbook Select PowerPivot from the menu ...Answered | 5 Replies | 2251 Views | Created by Deckerch - Thursday, October 6, 2016 11:26 AM | Last reply by Scott_PP - 16 hours 21 minutes ago -
15 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 | 45 Replies | 21213 Views | Created by Casniki - Monday, October 19, 2015 2:34 AM | Last reply by Sasteve - Thursday, October 17, 2019 4:02 PM -
0 Votes
How do I disable accessibility to password protect on the device?
How can I prevent my local users on the device to get access to the password protect excel & words files? We uses office 2016 & 2019. As for company ...Proposed | 4 Replies | 143 Views | Created by ChanWei21 - Thursday, October 10, 2019 1:43 AM | Last reply by Emily Hua - Thursday, October 17, 2019 12:34 PM -
0 Votes
Is there a MID function that starts from the right?
=MID(Cell;3;100) --> Black Yellow66 --> ...Proposed | 4 Replies | 56 Views | Created by BramBlue - Wednesday, October 16, 2019 10:50 AM | Last reply by Emi Zhang - Thursday, October 17, 2019 9:27 AM -
0 Votes
Counting rows until sum value reached
Hello, I am not able to make such simple thing work. Sheet contains values in column N and rows 10-500, I need to add these values until sum ...Proposed | 5 Replies | 98 Views | Created by fandango71 - Monday, October 14, 2019 11:24 PM | Last reply by Herbert Seidenberg - Thursday, October 17, 2019 2:47 AM -
0 Votes
The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator or driver vendor.
I am getting this the below error while expanding a table, that is being used in the filter. We have other tables as well, but the issue is not coming in it. I have an OLAP Cube and I am using Excel ...Proposed | 1 Replies | 47 Views | Created by xander1593 - Tuesday, October 15, 2019 2:29 PM | Last reply by Emi Zhang - Wednesday, October 16, 2019 8:36 AM -
0 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 | 5 Replies | 3980 Views | Created by Amy Dang - Wednesday, June 6, 2018 4:55 PM | Last reply by smundara - Tuesday, October 15, 2019 4:12 PM -
0 Votes
Need assistance for California overtime formulas
8 hours per day = 1.5 OT> 12 hours per day = 2.0 OT> 40 hours per week = 1.5 OTon the 7th consecutive work day, the first 8 hours = 1.5 OT, and 2.0 OT afterwards I am able to get the ...Answered | 3 Replies | 2595 Views | Created by K1NJO - Wednesday, September 17, 2014 11:27 PM | Last reply by SBS 2008 - Tuesday, October 15, 2019 3:50 PM -
0 Votes
Issue with Formula implementation
Iam currently working on a report, and facing issue with following implemetation "=IF(InterActive_Chart_TableName_2 = "Weekly_Data", INDEX(LP_TableDataCrunch, ...Proposed | 1 Replies | 127 Views | Created by Raghavarao - Friday, October 11, 2019 10:52 AM | Last reply by Emi Zhang - Monday, October 14, 2019 7:53 AM -
0 Votes
Add title over line in XY graphic
Hi all! I would like to tag the lines graphed in a XY graphic. I have the information like this TASK A ...Proposed | 2 Replies | 241 Views | Created by BLACKWOLF88 - Thursday, October 10, 2019 6:02 PM | Last reply by Emi Zhang - Monday, October 14, 2019 2:53 AM - Items 1 to 20 of 13168 Next ›
No announcements
