I have two different but identical computers with Office 365 (up to date to 1911, monthly channel) + Win 10 (both x64). In one computer Excel dynamic arrays work as expected, but not in the other. Should this happen and is there any way to "fix" it?
I have a large-ish .xlsx file that I keep live on sharepoint for multiple users to view/edit and it suddenly is saying that it has 'Unsupported Features' and external links. I've searched the whole workbook for external links and I have not found references to an external workbook in any cell. I...
I am creating a budget template. I am sharing it with two others but they haven't added any restrictions. For some reason, I can no longer click certain features in Excel (such as add border or font color). The workbook does have a macro which locks each of the three tabs when the file is opened...
I have Excel 2016 for Windows. All the features of the data tab are greyed out. The file is not protected. Anyone have an idea how I can access these features? The features under the other tabs are all active.
I feel like I'm abusing this forum with the amount of questions I have.
On Column A there is a list 300-strong of paper names. You can have things like:
Banbury Guardian - Mon
Banbury Guardian - Tue
First of all many thanks for all the good stuff on this forum!
I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help!
In my macro to protect I use:
ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True
I have excel files.
There are different sections in this file.
There are different features under each section.
Unequal weights are available for these features.
The sum of each section is 10.
However, if there are no features under a section, the weight of the non-features needs to be...
I was just wondering if I could get some help on sorting data. I recently started working at a car dealership for the summer and I'm having trouble finding the right vehicle trim levels for customers based on the features that they want. What would be the best way to do this in excel? In the...
I am very new to VBA coding features . My company given me database spread sheet in which there are about more than 150000 lines in that sheet.
So i need a user form to retrieve the data from the database spread sheet and edit the features and update the same in the field.
Hi everyone, Thank for coming in.
I have product informations and would like to seperate into 5 bullet point like below.
Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You...
There are some new features installed today:
vbOptimise - using regis caching to speed page load
Like/Thank posts - If you like a particular reply to a post, you can like the post. Anything with > 5 likes will appear in a special color
Cookie Control - to be compliant with the EU...