No announcements
-
0 Votes
Solver - Speed Differences Between Excel Versions
Hi - I am wondering if there is any difference in the processing speed of Solver as between 2010/2016/2019/365 versions of Excel - in particular, whether (1) newer versions of Solver will ... -
0 Votes
Copying sums from one worksheet to another
Hello, I've created a Sum column for multiple columns in excel for a payroll report. What I'm trying to do is take that Sum column and cut and paste onto a new master excel sheet. ...Unanswered | 1 Replies | 17 Views | Created by Book1969 - 3 hours 47 minutes ago | Last reply by Hans Vogelaar MVP - 2 hours 15 minutes ago -
0 Votes
Need help calculating the difference between first occurrence of value and most recent
Hi Everyone, I'm having some trouble figuring out how to show the difference between first occurrence of value and most recent occurence of that same ...Answered | 10 Replies | 335 Views | Created by Shane Culliton - Wednesday, December 12, 2018 11:57 PM | Last reply by Shane Culliton - 3 hours 50 minutes ago -
0 Votes
Sum possible values with equal count
Hello everyone, I have excel sheet with two columns, Col A have email addresses and Col B Mailbox Size. I want to get combination of Unique email addresses who ...Unanswered | 2 Replies | 27 Views | Created by ZakBhai - 18 hours 9 minutes ago | Last reply by ZakBhai - 3 hours 57 minutes ago -
0 Votes
Import/Export Colors
Hello, I have customized colors in Excel and then I wanted to export and deploy to all my organization It is possible? Where can I find the saved colors? ...Proposed | 3 Replies | 97 Views | Created by exitista - Wednesday, February 13, 2019 8:01 PM | Last reply by exitista - 5 hours 21 minutes ago -
0 Votes
Office Excel 2013 - Insert Object, Display as Icon Missing
Hi Microsoft Expert, We encountering issue when trying to Insert Object (PDF) , no matter create from file / create new, display as icon and the pdf icon is missing. ...Answered | 9 Replies | 37145 Views | Created by KJ Khoo - Monday, January 26, 2015 8:51 AM | Last reply by TDA1990 - 7 hours 34 minutes ago -
0 Votes
Conditions in excel
I have an excel document with two sheets in which I want to set a condition as follows: If the data in column A in the first sheet matches the data in column B in the second sheet, ...Unanswered | 1 Replies | 10 Views | Created by dpunair - 10 hours 19 minutes ago | Last reply by Hans Vogelaar MVP - 9 hours 30 minutes ago -
0 Votes
Excel 2016 crash Version 1901
workbooks.open) Excel closes without any errors and it happens on same and different files but not always, sometimes it's opening normal. Also there is no trace in "windows logs" ...Unanswered | 7 Replies | 43 Views | Created by Vytautas A - 13 hours 18 minutes ago | Last reply by Vytautas A - 9 hours 57 minutes ago -
0 Votes
Excel 365 VBA Cannot communicate with Powerpoint.Application, early or late binding
An app is working fine on my PCs and used to work on a client site until Feb 18. Now the line ... -
0 Votes
Power Query - Refresh Issues in Exported Excel
Hello Hope someone can help me with my issue. I have the below Query structure in my Excel. Basically, Volume/Base Price/Promo Rates etc. are merged to ...Proposed | 4 Replies | 186 Views | Created by Cristian Draja - Monday, January 21, 2019 1:55 PM | Last reply by Cristian Draja - 13 hours 30 minutes ago -
0 Votes
Average according to the conditions
>English<Unanswered | 1 Replies | 16 Views | Created by ZZuo - 21 hours 32 minutes ago | Last reply by Emi Zhang - 14 hours 55 minutes ago -
0 Votes
Excel Text Box Resizing
I have a spreadsheet with text box placed with cells below. Formated text box to resize to fit text. When the text box enlarges to fit text I need the cells ...Unanswered | 1 Replies | 21 Views | Created by Mark NT - Tuesday, February 19, 2019 5:08 PM | Last reply by Emi Zhang - 16 hours 26 minutes ago -
0 Votes
Hebrew letters. Final Sofit Issue.
0,VLOOKUP($M6,Alephbet!$A:$D,4),0),0) ] works great with all letters it cannot differentiate between mem מ and final mem ם. The same happens with the other four letter set. ...Unanswered | 5 Replies | 462 Views | Created by danielk1859 - Tuesday, May 3, 2016 2:21 PM | Last reply by danielk1859 - 18 hours 0 minutes ago -
0 Votes
EXCEL SPREADSHEET
AFTER A POWER LOSS ON MY COMPUTER I TRIED TO REOPEN MY FILE AND IT GIVES ME AN ERROR CODE THAT(FILE EXTENSION DOES NOT MATCH THE FORMAT OF THE FILE) SAYS FILE FORMAT ON FILE EXTENSION IS ...Unanswered | 2 Replies | 48 Views | Created by BONNIE BIRLEW - Monday, February 18, 2019 6:47 PM | Last reply by Ashidacchi - 21 hours 4 minutes ago -
0 Votes
Summarise table for non-contigous rows
I have several tables that analyse sick leave data. I use formulas that attribute a value only if the value is not zero (leave actually taken). The table has subtotals for each category of sick ...Proposed | 5 Replies | 170 Views | Created by Jim from Oz - Wednesday, February 6, 2019 8:10 AM | Last reply by Ashidacchi - 21 hours 41 minutes ago -
6 Votes
Power Pivot - The option get external data from Other Sources is not working
Power Pivot, the option get external data from other sources is not working. Clicking the "From Other sources" button does nothing. The other options work normally. This button has worked ...Unanswered | 17 Replies | 591 Views | Created by marciofb14 - Sunday, February 10, 2019 9:47 PM | Last reply by presidentgian - Tuesday, February 19, 2019 10:32 PM -
0 Votes
Table Import Wizard does not load
From other Sources a Table import wizard should popup allowing me to select my data source i want to load. in my case the import wizard no longer ...Unanswered | 4 Replies | 142 Views | Created by Skeezixix - Thursday, February 7, 2019 5:53 PM | Last reply by Skeezixix - Tuesday, February 19, 2019 6:41 PM -
0 Votes
Could not load file or assembly "System.Data.dll" or one of its dependencies. Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
dir c:\System.Data.dll /s ...Answered | 4 Replies | 399 Views | Created by pjg066 - Sunday, January 6, 2019 10:59 AM | Last reply by pjg066 - Tuesday, February 19, 2019 9:23 AM -
0 Votes
Probelms with formatting for expiring dates
less than>=TODAY()+30 Applies to $G$2:$G$160 (red) -Cell Value>less than>=TODAY()+60 Applies to $G$2:$G$160 (orange)Proposed | 2 Replies | 113 Views | Created by Brillet Delgado - Monday, February 11, 2019 8:32 PM | Last reply by Emi Zhang - Tuesday, February 19, 2019 8:59 AM -
0 Votes
new web query (not responding) under windows 10
When I try to export a page from imdb to excel 2016 from Internet explorer on windows 10, the new web query becomes unresponsive. all it says is 'waiting for' at the bottom. is there a way I ...Proposed | 2 Replies | 94 Views | Created by patdiddy - Monday, February 11, 2019 9:58 PM | Last reply by Emi Zhang - Tuesday, February 19, 2019 8:59 AM - Items 1 to 20 of 12873 Next ›
No announcements