Forum

Catalin Bombea
@catalinb
Admin
Member
Joined: Nov 8, 2013
Last seen: Dec 22, 2025
Topics: 1 / Replies: 1937
Reply
RE: Excel Hangs when attempting to either record a macro, execute a macro, view code, etc.

Well, I did mentioned Option 2 should be applied. Here is what that step says, with big red letters: Option 2 - Completely uninstall Office with...

10 years ago
Forum
Reply
10 years ago
Forum
Reply
RE: Excel Hangs when attempting to either record a macro, execute a macro, view code, etc.

Hi Monte, What do you mean by "reloaded Office 2013"? You should try a clean reinstall, you have to completely remove the existing office installation...

10 years ago
Forum
Reply
RE: Using VBA to Create PDF's from Excel and Automatically Emailing

Hi Bruce, You're lucky, I have a code that is very similar to what you need. You can try the file attached. Cheers, Catalin

10 years ago
Forum
Reply
RE: Macros disabled when opening workbooks in OneDrive

Hi Tony, Make sure there are no Group Policies restricting macros. Also, note that template files .xltx, .xltm are not considered trusted documents...

10 years ago
Forum
Reply
RE: (Extract)

Hi Scott, The advanced filter is creating a defined name "Extract", where the results of the advanced filter will be pasted. In excel, by default, w...

10 years ago
Reply
RE: Speeding up Power Pivot

Hi Martin, My guess is that there are multiple iterators in your data model (an iterating formula is any "X" formula like SUMX for example). Even F...

10 years ago
Forum
Reply
RE: Fractional Shares with any combinations to form Any Integer

Hi Perry, Can we see a sample file, and a manual example of how the result should be? Be generous with details, any information is important. ...

10 years ago
Reply
RE: FORMULA TO DISTRIBUTING VALUES AUTOMATICALLY ACROSS CELLS

You better hide that column, because the formula needs a starting point, to calculate the cumulated values. And that starting point cannot be in colum...

10 years ago
Reply
RE: Email Notifications when excel file modified

Hi Nina, I removed your email from each file from this topic, you will not receive those messages. Cheers, Catalin

10 years ago
Forum
Reply
RE: FORMULA TO DISTRIBUTING VALUES AUTOMATICALLY ACROSS CELLS

Hi Meyanui, Try this formula in F5: =IF(AND(F$2>0,$D5-SUM($E5:E5)>0),MIN(F$2,$D5-SUM($E5:E5)),0) You can copy it to the right and down ...

10 years ago
Reply
RE: Spreadsheet Slowing Down!

Hi Paul, From the first look, the data structure is not right. Any database should expand in rows, not in columns. Data strored in excel should res...

10 years ago
Reply
RE: Using IF in Power Query (want to fill only text below it wherever the numbers are present until you reach a text)

Hi Arvind, Try this formula in a new custom column: if (try Number.From([Column3]) otherwise "Text") ="Text" then "Text Found" else null You ...

10 years ago
Forum
Reply
RE: Create Outlook Email with Email Addresses & Text Body in Excel

You can also try the code and sample workbook from our website: You can remove the PDF attachment part, and improve the message. If you want more c...

10 years ago
Reply
RE: Spreadsheet Slowing Down!

Hi Paul, There are no attachments, make sure you press the Start Upload button after you add files to the Upload Queue, as described in the Upload ...

10 years ago
Page 121 / 130
0