Well done Microsoft :mad:
Type: Posts; User: rvWoody; Keyword(s):
Well done Microsoft :mad:
I understand that but I'm still annoyed because the PDF file opens in Word (online) and not in Acrobat Reader. Even for the non-original account (but that account too has Office 365). I wonder what...
Yes I do. When the link is accessed from another account, the "edit in word" button is not there.
I still find the behaviour strange, especially because the link was created as read-only.
I created a PDF file (save as PDF in word) and saved it to my OneDrive storage.
I then created a read only link for that file
When the link is clicked, the file opens in Word Online
Nope. Works only for Windows (and Mac), not for iPads.:(
I found the problem: in the 'Protect sheet' pop up window, I had unchecked 'select locked cells', because I mistakenly thought you would then be able to change that cell.
I recently bought an iPad Pro - which came pre-installed with the Dutch language. Which is fine for me. However, I want to install Office 365 (especially EXCEL) with the English language (as...
Is it possible to have a locked cell as the 'Set Cell' of a Goal Seek?
The 'Set Cell' contains a worksheet formula that I don't want to be destroyed, so I protected the worksheet (which in turn...
Access data base created with access 2010, encrypted and opened in access 2016
Following code is used (in EXCEL) to open the data base:
Dim strProvider As String
But 'formula' cells do not trigger a change event? There is something I don't undderstand.
The 'final' code posted above suffered in a reality check from two major problems:
1. The change event is not fired for a calculated value. In the real spreadsheet, the Alpha cells contain a (user)...
The sample code above changes all sparklines in the Trend column, whether Alpha has been changed or not. It also contains cell references and depends on the Trend cell being located in front and...
I adapted the solution zeddy offered. It was not clear in the Original question that the data were arranged in a table. Therefore, I had to Ungroup the Sparklines to make it work: ...
Is it possible to colour the sparklines based on a value in another column (e.g. C - When positive: Green, Negative: Red, Otherwise: Neutral blue)?
@Rory: this is indeed an elegant way to achieve the desired result. Congratulations.
However, I have to stick with a (modified) UDF. As you observed the NULLs spoil everything. To further...
Thanks for your replies. I was already afraid that no compact solution could be found within the set of Excel functions. What further complicated the issue was the presence of Nulls in the data set...
Following table was pulled from an SQL Server data base and shows dividends paid over the past years.
I want to count how many times the dividend was at least equal or greater than that...
I can't insert a symbol into a Name. I get all shades of Grey :( - see attachment
zeddy, I do consider a named range as a reference. I do agree that the use of a name is less error prone.
Thanks again to all: copying a reference to a spreadsheet cell that contains the symbol and constructing the formula around it in the formula bar does the job.
Thanks to all for replying so quickly.
The most straightforword solution would be the use of Maudibe's suggestion: =IF(ERROR.TYPE(A1)=2,"∞"), but if I try to insert the ∞ symbol (from the math...
Is it possible to represent the symbol for infinty as result of a calculation? I want someting like this:
IFERROR (some calculation, "Symbol for infinity")
The following article seems to suggest...
The more generic question can be solved by using dynamic SQL. Interpreting some googled results, I put the following reminder to myself together:
1. Define an SQL variable...
You must add a Parameter object before executing the query. Examples of how to do so can be found at:
VBA,ADO connection an query parameters
How to invoke a parameterized query using VBA
Yes, I did and got the same error.
Following code did circumvent the problem:
ISNULL(,0) as ,
ISNULL(,0) as ,
ISNULL(,0) as