No announcements
Found 19167 threads
-
4 VotesVBA to clear the Immediate Window
When developing a macro I often use Debug.Print to show results in the immediate window and then have to manualy delete the contents of the immediate window between ...Answered | 3 Replies | 65334 Views | Created by Steve Staab - Sunday, November 28, 2010 3:55 PM | Last reply by Agent_F13 - Monday, December 7, 2020 8:54 AM
-
0 Votes
Best server setup for Microsoft Analysis Services
Hi, I'am a BI developer and I have some problems that the SSAS server is running out of disk while I am processing a cube. I noticed that the ... -
0 Votes
business model, monthly subscritption - Excel spreadsheet
Hello guys, I'm working to create a solution to a company as an independent consultant. I'll be paid by result as soon I deliver the product. The product is a set of ... -
0 Votes
Ribbon UI
How to collapse and expand Ribbon UI programmatically (VBA)?Unanswered | 2 Replies | 1319 Views | Created by Hassan Abaza - Thursday, November 26, 2020 9:19 AM | Last reply by isladogs52 - Thursday, December 3, 2020 9:56 PM -
0 Votes
Excel crashed many time
Log Name: Application Source: Application Error Date: 03/12/2020 ...Unanswered | 0 Replies | 1074 Views | Created by Boussaadan Abderrahim - Thursday, December 3, 2020 11:24 AM -
2 Votes
charts and shapes does not move when row inserted in excel in c# programmatically
When i insert a row in excel charts and other shapes does not move with their cells. Lets say i have a chart at A5:D:10, then i insert a row below 2nd row, so ...Answered | 6 Replies | 7859 Views | Created by j4m4l - Thursday, April 19, 2012 9:31 AM | Last reply by Lagonexus - Wednesday, December 2, 2020 10:33 PM -
1 Votes
Conditional Formatting, Stop If True can't force it to stop
hi all, I to put a length limit on a column input through the Conditional Formatting Rules Manager. If the formula is valued TRUE, the text get red color which set off an ...Answered | 2 Replies | 1397 Views | Created by sesquipedalian - Friday, November 27, 2020 9:36 PM | Last reply by sesquipedalian - Tuesday, December 1, 2020 5:42 PM -
0 Votes
I am getting Rogue Grand Totals in my excel spreadsheet
I am getting Rogue Grand totals in my Excel Spreadsheet when I insert Sub-Totals into my worksheet. My Code: Public Function SubTotalBudgetSummary(ixlsxWorkSheet ... -
0 Votes
Excel Power Pivot crashes only when connecting to OraOLEDB.Oracle source
Provider=OraOLEDB.Oracle;Persist Security Info=False Powerpivot works well with other sources say connecting to another excel file but when I try to connect to ... -
0 Votes
Jump to next row when cell is selected
Hello, I need to make the entry of data in sheet more faster, where when user reach last cell in the row, excel jumps to next below row without using the ...Answered | 2 Replies | 1171 Views | Created by Ahmed Morsyy - Saturday, November 28, 2020 10:31 AM | Last reply by Ahmed Morsyy - Saturday, November 28, 2020 1:10 PM -
1 Votes
Excel 2013 is crashing when maximized programmatically whith no opened document
0) Call ActiveWorkbook.Close(False) Wend Application.WindowState = xlMaximized End ...Proposed | 5 Replies | 2174 Views | Created by Vel Thaidis - Tuesday, August 20, 2013 2:24 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, November 25, 2020 7:49 PM -
0 Votes
Refresh BackgroundQuery:=False
Hi, Im getting this error for a while and dont know why, basically I made a macro for a sap report, then the below code is to instruct to open that file from access, however ... -
0 Votes
VBA Error 445 on MacOS with Shape.Fill.UserPicture()
(This is a question I posted at StackOverflow too (can't give a URL with current permissions), but haven't gotten an answer yet.) I'm trying to use some code in ...Unanswered | 1 Replies | 1042 Views | Created by ColinC2020 - Tuesday, November 24, 2020 7:14 PM | Last reply by KHURRAM RAHIM - Tuesday, November 24, 2020 9:39 PM -
0 Votes
Calling ListObject.Unlist() removes filters
Hi all; Ok, to set a Range.Formula or Range.Value2 in a single cell in a table, and not have it duplicate, I called ListObject.Unlist() as suggested here. Works ...Unanswered | 1 Replies | 1071 Views | Created by DavidThielen - Tuesday, November 24, 2020 12:40 PM | Last reply by Hans Vogelaar MVP - Tuesday, November 24, 2020 12:48 PM -
0 Votes
Excel timeline on SSAS date dimension, possible to restrict dates in TL but retain other dates in dimension?
Hello all I have an SSAS cube, and there's a date dimension. For various reasons I need the dim dates to go back to 19000101 and forward to 2050 etc....there's a whole load of ... -
0 Votes
Assigning to Range.Formula or Range.Value2 duplicates assignment to all cells below assigned cell - in table
Hi all; Please take a look at ATE-4253.xlsx. It has a table in it as shown here: If I assign a string to B9 using ...Answered | 4 Replies | 1560 Views | Created by DavidThielen - Saturday, November 21, 2020 4:29 PM | Last reply by DavidThielen - Sunday, November 22, 2020 11:48 AM -
0 Votes
Powerpivot Equivalent for Excel SUMIFS Where Lookup Field Contains Partial Text from Another Field
Morning all, I am relatively new to DAX and have scoured the forums but not found anything that quite works in Powerpivot/Dax yet. I am trying to sum each record ...Unanswered | 2 Replies | 1149 Views | Created by Merc100 - Friday, November 20, 2020 12:45 PM | Last reply by Herbert Seidenberg - Friday, November 20, 2020 8:28 PM -
2 Votes
Using SQL within a Excel workbook
Guys - I remember doing this years ago with VBA and a special driver. Can someone please refresh my memory as to exact details. As I ...Answered | 4 Replies | 1467 Views | Created by Syswizard - Monday, November 9, 2020 4:21 PM | Last reply by Syswizard - Thursday, November 19, 2020 7:51 PM -
0 Votes
How to minimize the shared drive's name in a file path for inserting into the footer in Excel 2010?
Hey there, I want to know how to shorten the drive's name for the file path that I want to add into the footer of a worksheet in Excel 2010. The worksheet is ... -
1 Votes
Run Time error 1004 for Excel in Office 365 Pro Plus
Afternoon, We had simple macros on the older Excel versions that worked fine and when we upgraded to the latest version they do not work anymore. We deleted the installed macros and ...Unanswered | 2 Replies | 1267 Views | Created by Vyledeedes - Wednesday, November 18, 2020 6:45 PM | Last reply by Vyledeedes - Thursday, November 19, 2020 3:10 PM
No announcements
