No announcements
-
0 Votes -
12 Votes
How to hide a slicer?
Hi, I want to be able to totally hide the slicers in my sheet. The idea is that the user can select the slicer items they want to see and then hide the slicers ...Answered | 18 Replies | 32463 Views | Created by UpsideDown55 - Tuesday, November 13, 2012 12:39 PM | Last reply by THammer70 - 7 hours 47 minutes ago
-
0 Votes
Excel issues - workbook works on all computers in office but on
I can't seem to find an answer online anywhere because mostly formula solutions come up but my issue is this: When our office administrator opens a workbook, even one she saves and ...Unanswered | 4 Replies | 25 Views | Created by Justunderwood - Wednesday, October 17, 2018 9:20 PM | Last reply by Justunderwood - 7 hours 57 minutes ago -
0 Votes
Add a condition to a formula HELP
=IF('O:\Inventory\[PROP1819.xlsx]PROP'!$E63<>"",'O:\Inventory\[PROP1819.xlsx]PROP'!$E63,"") I want to add a condition to this ...Answered | 3 Replies | 39 Views | Created by MrGuinnss - Wednesday, October 17, 2018 4:06 PM | Last reply by MrGuinnss - 9 hours 45 minutes ago -
0 Votes
Printing sheets with slicers problem
Hello, Whenever I try to print a page that contains a slicer, the slicer content prints larger and are badly displayed. If we look at the sheet the ... -
0 Votes
MS Excel restarts when I attempt to record/create a macro
Hi! MS Excel keeps closing or restarting when I attempt the following: * record a macro * insert a new module * open an ...Unanswered | 1 Replies | 20 Views | Created by Kai Keeler - Wednesday, October 17, 2018 10:58 PM | Last reply by Emi Zhang - 14 hours 23 minutes ago -
0 Votes
One drive/Excel Online Survey : Problem Submitting Survey
Hi After 450 successful submissions the Survey has stopped accepting submissions. There have been no changes to the share status of the file. I have already tried re sharing ... -
0 Votes
Data gets deleted after repairing excel file
When i open the excel file it asks to repair and when i repair it deletes all the saved data, and shows previous dataProposed | 3 Replies | 180 Views | Created by parul1307 - Saturday, November 4, 2017 12:01 PM | Last reply by Sandy Cullen - 17 hours 46 minutes ago -
1 Votes
How to repair excel file?
I have a corrupted excel file, in the sense , when I try to open my excel file, it says it is corrupted and the file has some Unsupported data and if I proceed to open, it says the Unsupported data ...Answered | 10 Replies | 3037 Views | Created by YorkWenspire - Friday, April 25, 2014 8:53 PM | Last reply by Sandy Cullen - 17 hours 59 minutes ago -
1 Votes
Error connecting a Sage 50 Accounts ODBC database to a sheet in Excel:- "Unexpected error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ---> System.AccessViolationException: Attempted to ...Proposed | 12 Replies | 1128 Views | Created by BeckeyB74 - Thursday, October 5, 2017 9:47 AM | Last reply by Chris Green 101 - Wednesday, October 17, 2018 2:10 PM -
0 Votes
PowerPivot error "this table has been already added"
Hi guys, I have 30 tables in excel files. Every table has unique name "table1", "table2", "table3" etc. problem is that I added ...Unanswered | 1 Replies | 40 Views | Created by LukasBeSK - Tuesday, October 16, 2018 9:20 AM | Last reply by Emi Zhang - Wednesday, October 17, 2018 8:08 AM -
0 Votes
Adding values in column A for equal values of column B in Excel
Hello!! So I need to sum all the values in column A for equal values of column B. The point is to sum all values in column A corresponding to 85,98 (in this ...Unanswered | 3 Replies | 81 Views | Created by jota17 - Tuesday, October 16, 2018 4:29 PM | Last reply by Emi Zhang - Wednesday, October 17, 2018 7:58 AM -
0 Votes
Opening a dialogue slows down dramatically after a while
Hello I have created a large excel application using a lot of dialogues through VBA. In my own computer I have no performance issues. With some users the performance may slow down ...Unanswered | 2 Replies | 35 Views | Created by Matti from Northern Finland - Tuesday, October 16, 2018 7:42 AM | Last reply by Yuki Sun - Wednesday, October 17, 2018 6:00 AM -
1 Votes
Formatting cells for time duration
I know the options to format time in Excel but I keep running into this problem: How do I represent time by duration? ...Answered | 15 Replies | 349 Views | Created by ResidentX10 - Sunday, March 11, 2018 7:51 PM | Last reply by ResidentX10 - Tuesday, October 16, 2018 6:20 PM -
0 Votes
Sorting a list/values that are spread out over multiple columns
I am trying to alphabetically sort a list that spans multiple columns in Excel and while it seems like an easy task, I have not found a way to do it. For argument's sake, let's say there are ...Unanswered | 2 Replies | 49 Views | Created by Handsome Prints - Tuesday, October 16, 2018 1:14 AM | Last reply by Herbert Seidenberg - Tuesday, October 16, 2018 3:25 PM -
34 Votes
Excel 2016 always opens blank when double clicking an xlsx
Greetings, Having just installed Office 2016, I now have this very annoying feature with Excel 2016 that whenever I click and xl spreadsheet file it starts excel but ...Proposed | 35 Replies | 135823 Views | Created by David Zemdegs - Monday, October 5, 2015 4:53 AM | Last reply by Justin Serlick - Tuesday, October 16, 2018 3:02 PM -
0 Votes
Excel 2016 Maps - two states not populating in map (Louisiana and Mississippi)
I have a list of states and a column with numbers associated with them. When I selected to insert map, all information except for Louisiana or Mississippi appeared. They ...Answered | 4 Replies | 75 Views | Created by Siskoy - Friday, October 12, 2018 1:22 PM | Last reply by Siskoy - Tuesday, October 16, 2018 1:17 PM -
0 Votes
Get Data - Error fetching Columns MetaData
Using Office 365 / Excel 2016 (32bit) Version 1808 (Build 10730.20102 CTR) - Semi Annual Channel. We have an Oracle DB, for which I have created various PowerPivot reports in ...Unanswered | 2 Replies | 78 Views | Created by timlang - Friday, October 12, 2018 8:25 PM | Last reply by Herb Gu - Tuesday, October 16, 2018 3:03 AM -
28 Votes
Microsoft Excel cannot paste the data
Hi, I have a user that is working on a Vista Terminal Server with Excel 2010 on it. The user will copy a large amount of data in Excel 2010 and try to paste it into Excel 2010 ...Proposed | 41 Replies | 380985 Views | Created by CMiniC - Wednesday, February 2, 2011 4:42 PM | Last reply by Rachel Wallace - Monday, October 15, 2018 7:43 PM -
0 Votes
Quick Analysis - clicking on TOTALS crashes Excel 2013
Whenever I click on the TOTALS heading in Quick Analysis (after selecting a small range of cells all of which contain numbers) in Excel 2013, the application crashes. I have already tried safe ...Unanswered | 15 Replies | 5214 Views | Created by JSA1987 - Monday, March 24, 2014 11:09 PM | Last reply by Oskar Salazar - Monday, October 15, 2018 4:03 PM - Items 1 to 20 of 12639 Next ›
No announcements
