No announcements
-
0 VotesExcel 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 | 7 Replies | 1610 Views | Created by Conroe997 - Thursday, March 1, 2018 7:56 PM | Last reply by John P.16 - 2 hours 23 minutes ago
-
0 Votes
Autosave turned off - This workbook contains features that prevent it from using Autosave.
Hi, Please I need some help here. I have a ton of excel files that come up with this error and I am unable to enable the autosave feature on these work ... -
0 Votes
Dynamically Change form Label value
Hello We have a large Workbook with a number of pivots that take about 20 minutes to refresh. I want to provide a splash screen that displays the update status. It’s mostly ...Unanswered | 1 Replies | 22 Views | Created by ryand09 - 9 hours 27 minutes ago | Last reply by Hans Vogelaar MVP - 8 hours 2 minutes ago -
0 Votes
Request of saving file
Good morning sirs, My Excel presents a weird behaviour: even if i save with the floppy disk icon, the program asks me tif i want to save before closing. Is there ...Unanswered | 3 Replies | 126 Views | Created by andrea vironda - Wednesday, May 15, 2019 5:56 AM | Last reply by GMY_LFE - 12 hours 54 minutes ago -
0 Votes
Excel front end and results from detail in same workbook
> One tab as a menu, where users select options from a drop down menu >> Second tab with rows of data to be used for generating filtered ...Answered | 1 Replies | 95 Views | Created by stamandk - Friday, May 17, 2019 11:16 PM | Last reply by stamandk - Sunday, May 19, 2019 12:52 PM -
0 Votes
Excel 2016
Hello, We have Excel 2016 on Xenapp 7.15. Three users have reported a problem on Excel 2016. When it opens two excel files ...Proposed | 6 Replies | 273 Views | Created by techsupsie - Thursday, March 14, 2019 6:57 AM | Last reply by techsupsie - Saturday, May 18, 2019 1:00 PM -
0 Votes
Excel 2016 Default Gridlines No Longer Display
I have been contacted by one of our users who stated that all at once the gridlines, which were set on by default, have disappeared. He can turn them back on using the various settings but, since he ...Unanswered | 7 Replies | 160 Views | Created by Bruce-Pilgrim - Thursday, May 9, 2019 8:08 PM | Last reply by Bella Wu - Friday, May 17, 2019 2:55 AM -
0 Votes
pivot table not showing rows with empty value
i am creating a pivottable from a datatable which contains rows from a OUTER JOIN query...so there are rows with some fields empty...i added one of the fields to the pivottable rows list but it ...Answered | 6 Replies | 152 Views | Created by sunisha - Sunday, May 12, 2019 1:24 AM | Last reply by Bella Wu - Friday, May 17, 2019 2:46 AM -
1 Votes
Help with bringing in results with a index or vlookup in a sorted order (Ascending or descending)
I am currently using this ...Answered | 1 Replies | 87 Views | Created by Dustin Shepard - Thursday, May 16, 2019 4:19 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, May 16, 2019 7:23 PM -
1 Votes
PowerPivot not loading - Not visible on the ribbon
I have been using PowerPivot for one year. Suddenly PP was not loading and PP did not show up on the ribbon. I have googled this problem and many have the same problem. But I have still not found the ...Answered | 12 Replies | 22106 Views | Created by Helge Klungland - Wednesday, October 31, 2012 11:28 AM | Last reply by Thabet Muhsen - Thursday, May 16, 2019 11:22 AM -
1 Votes
print to pdf?
started using 365 today; can't find set print destination box If Microsoft 'print to pdf' cannot be used, I can always revert to office 2010 which works fine for ...Proposed | 3 Replies | 448 Views | Created by rob124c41 - Monday, February 19, 2018 6:23 PM | Last reply by MartinSmith0021 - Thursday, May 16, 2019 11:20 AM -
0 Votes
Excel spreadsheet becomes unable to edit, have to switch to another workbook and back to unfreeze
Hi, I have multiple users who while working in Excel their current workbook will essentially freeze, or put into a state where they cannot input/edit ...Proposed | 1 Replies | 72 Views | Created by dukesalami - Wednesday, May 15, 2019 9:03 PM | Last reply by Emi Zhang - Thursday, May 16, 2019 9:47 AM -
0 Votes
Query Wizard does not start and MSQuery hangs in the background
Other Sources>From Microsoft Query> and I have the use wizard to create/edit queries checked, MS query starts in the background but the wizard does not start. MSQuery ...Proposed | 1 Replies | 81 Views | Created by Jim Excel - Wednesday, May 15, 2019 8:27 PM | Last reply by Emi Zhang - Thursday, May 16, 2019 9:34 AM -
0 Votes
Conditional Formatting
I am trying to apply an extremely simple conditional format to a column of cells, but it is not working. I have highlighted the column I want, clicked on Conditional Formatting, clicked ...Proposed | 2 Replies | 96 Views | Created by Lori71 - Tuesday, May 14, 2019 8:15 PM | Last reply by Bella Wu - Wednesday, May 15, 2019 9:26 AM -
0 Votes
SharePoint Lists Fail to Refresh after upgrade to Win10/Excel 2016
I have a spreadsheet which contains several lists where the data is retreived from SharePoint using Data Connections. The RefreshAll command runs without error in both Win7/Excel 2013 and Win10/Excel ...Unanswered | 4 Replies | 171 Views | Created by Martin.Swanston - Tuesday, May 14, 2019 10:06 AM | Last reply by Chelsea Wu - Wednesday, May 15, 2019 7:41 AM -
6 Votes
Excel 2010 Conditional Formatting not working for a range of cells
It appears that Excel 2010's conditional formatting is broken. I'm trying to format a range of cells using a formula. If I set conditional formatting to highlight a ...Answered | 14 Replies | 124848 Views | Created by plogan73 - Saturday, June 30, 2012 2:51 PM | Last reply by m_m_s - Wednesday, May 15, 2019 7:16 AM -
9 Votes
Sort data with SUMIFS formula
I am using the SUMIFS to summarize on hand inventory value based on item categories and a couple of other criteria. I would like the report to be sorted in descending order based on ...Answered | 10 Replies | 19139 Views | Created by B Schroeder - Wednesday, January 26, 2011 2:24 PM | Last reply by Bardsie - Tuesday, May 14, 2019 3:32 PM -
0 Votes
Trying to add if statements to leave sections of a work schedule blank when not scheduled
Right now I have start and end times in my schedule. I would like to wake up 3 hours before my start times and have that automatically calculated. I currently ...Proposed | 2 Replies | 149 Views | Created by d4ler - Thursday, May 9, 2019 7:38 PM | Last reply by Emi Zhang - Tuesday, May 14, 2019 8:18 AM -
0 Votes
SUMIF and SUMPRODUCT forumla not working - SO FRUSTRATED
HELLO, Can anyone please help me to understand what I'm doing wrong and how to fix? I'm using MS Office 365 ProPlus 2019 What the heck am i doing ...Proposed | 7 Replies | 156 Views | Created by It's me, AK - Thursday, May 9, 2019 1:08 AM | Last reply by Emi Zhang - Tuesday, May 14, 2019 8:17 AM -
0 Votes
Data (Stock)
Hi, Does anybody know if it's possible to get more values from the Excel stock function? Or any other way? I need these ...Proposed | 1 Replies | 94 Views | Created by Tirrazo - Monday, May 13, 2019 10:15 AM | Last reply by Emi Zhang - Tuesday, May 14, 2019 6:20 AM - Items 1 to 20 of 12988 Next ›
No announcements
