The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets
Currently we are utilizing insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…
Table transform in Excel
Hello, I have raw data that are extracted in complex design, so I need to transfer these data from below: to below design: There are thousands of Customers IDs and thousands of Parts and Parts type, each part has 2 subtypes, so subtypes need to be…
macros et classeur partagé
Bonjour, j'ai un classeur tout simple : une feuille liste de personnes avec une colonne pour le nom et une autre pour le numéro d'adhérent. La feuille est protégée pour éviter les erreurs de manipulation. Ce classeur doit être partagé sur un réseau…
How to setup custom expiry dates for tasks with visual reminders
Hi, I am creating a custom show management tool using MS Excel. I need help with setting up expiry dates. The expiry dates will work backwards from the show start date (B3) and change colour. Colour changes will include no change when still ok, orange…
How to renew Microsoft 365 Developer licence
I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program
Share Excel File to Power Macros Spreadsheet
Hey all, I hope someone already has done something similar as I am hitting a wall. In the team we have a spreadsheet on local network where we list part with some parameters; The data is used to run Macros to produce pdf drawings i.e. combine image with…
How to fix Mdxscript(model) (6,68) calculation error in measure 'Sheetname': Function 'Dateadd' only works with contiguous data selections:
Hi team, I have encountered the below error message when refreshing the data. The query did not run or the Data Model could not be accessed. Here's the error message we got: Mdxscript(model) (6,68) calculation error in measure 'Sheet name': Function…
Excel 365 when closing a window appears, The error '1004' has occurred at runtime:
Excel 365 when closing a window appears, The error '1004' has occurred at runtime: Error defined by the application or the object. I already reinstalled the office and it remains the same, any ideas????
Excel: Setting up Conditional Formatting for Skill Expiry Dates
Hello, How can I set up conditional formatting for expiration dates in Excel? I have a sheet with names in a column, skills across the top, and dates in the cells specifying when these skills were completed. There are four types of skills that expire…
Excel Automate Changing Formula on Corresponding Tabs.
I am trying to use the Automate feature to simplify some data structuring for my team. Once properly arranged said data is dispersed across two tabs in the same file using a Filtering formula. Once I engage the Automate function the formula on the…
Excel copy and paste issues
Excel copying problem: For example, if a cell is entered with a value of 1 and two blank cells are selected with the mouse, the content cannot be pasted and only one image with a value of 1 can be pasted. But copying this cell to a blank cell can paste…
Excel is showing below error.Also, Microsoft Office365 Marketing email keeps on popping up on right side.
Screenshot 2024-09-26 182800.png
Autofilter and Sort functions on Protected shared Excel file breaking down periodically with user's input
Hi all. We are having quite an issue in our company: I did set up an Excel file with macros enabled that allowed, out of 62 columns and 402 rows; to basically input data in multiple ways across the columns (dropdowns, text, date...); as well as having…
Export from SQL server to Excel with rich-text staying in each cell
Need to export from SQL server database to Excel. Data type is ntext and contains rich text. I need the data from each record to maintain within one Excel cell and preserve the rich text, i.e. line breaks and formatting.
How do I use a function on a table column in Query, when I want the inputted report to translate into a different number in Excel? Update: I need syntax help
I know my title is confusing, it's the best I could do. I am inputting an Excel report into Query, to organize it and lay it out on a spreadsheet. One of my values I want to show up as a duration, based on the date that came in on the report. For…
PivotTable in Excel
Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…
The 0 and null in the condition of the IF function
If A1=0, then B1 displays' No ', If A1 is null, then B1 displays "/", Otherwise, B1 will display 'Other'
Unable to permanently grey out macro settings in Office 365 Apps for Business
Hi, I am trying to lock down macros, primarily in Excel. Clients have Business Premium, Windows 11 Business and Microsoft 365 Apps for Business, managed by Intune. I also have a Windows 2019 1809 RDS server for testing which has Microsoft 365 Apps for…
COMMENT CREER PLUSIEURS LISTES DEROULANTES DANS UNE CELLULE, EN FONCTION DE LA REPONSE QUI APPARAÎT DANS LA CELLULE DE GAUCHE
Bonjour, Je souhaiterai créer un fichier excel avec la possibilité de faire apparaître plusieurs liste déroulante dans une cellule, en fonction de la réponse qui est choisie dans la cellule de la colonne précédente. Exemple : J'ai réussi à le faire pour…
Migrate VBA to vb6, vb.net, or c++
I have VBA code heavily integrated with Excel and it also creates shapes that will be put into a Powerpoint slide. I want to be able to create an exe file for distribution. What language is best to convert to VB.Net, VB6, C++ ?