Forum Discussion
Teams Custom Background Fails
- May 15, 2021
Hi Isabelma5
First, simplify it, don't start referencing ranges in another workbook.
Make sure your Drop down List Sheet is in the same workbook. This is why you receive an error message Cannot find the specified range
or you can share your workbook privately and I'll set it up right now and send it back to you. my e-mail
is: exo7450 at comcast dot netI tried referencing a data validation range from another workbook and received the error message, see image below:
Also note how I have defined the
Centers drop-down selection list, it is defined as a spill range using the . UNIQUE(Table1[[[[#All],[All]])Also note that the validation range of the drop-down menu ends with a
which is important if your drop-down selection is a spill range: 'DropDownList!$D$2' #
Let me know if you have any other questions or clarifications about it.
Bless you
DanZ24 I am having similar issues with the upload. I can put the file in the appropriate folder under %appdata% and it works. I don't understand the aspect ratio > 4, part. the files I am using are 1920 x 1080 (16:9 aspect ratio). The other odd thing is that we were able to use the add new on the same files a couple of days ago without issue. We setup a webpage with our branded backgrounds and gave the users instructions on how to save them and add them use the Add New feature and now it does not work.
scm2423The 16:9 aspect ratio will satisfy the >4 ratio. I'm using the same and have the issue.
- Donald_Genes_Oct 23, 2021Brass ContributorI can help you
First you need how to use logical function to manipulate the data
and then extract the time from the date
Send me a full details on my email or DM..I can help- Oro91120Feb 14, 2024Copper Contributor
Donald_Genes_ the easiest way is to use a third party to get the data. If you need market data only, cryptosheet is good. If you want to pull your wallets data from Binance for example, LinkyFlow is a better options.
If you want to do it without, you will need to go deep in VBA to get the data, or create your own addin.
- GabrielLukeJun 08, 2020Copper Contributor
I am quite sure there will be sufficient developers to reuse existing blockchain packages rather than just writing them. Save them time and encourage them to focus on the coding or adaptation of their token. Don't tell me that, instead of reuse existing frameworks and packages, you 're writing all your code as a developer. It is now quite standard to use existing packages by combining and building them with a unique solution. I don't see why it would be any different to blockchain. The basics need not be continually reinvented and developers reuse current products already.