Working with workbooks shared via Teams/Sharepoint
Hello Excellers, I need some insight on an issue that I am not sure what the source is... A) We sometimes share workbooks via Teams. You know when you are in a particular chat and next to the name of the chat at the top of the screen you see Shared and then you see Files button a bit below the Shared menu and when you click on that Files button you will see a list of what workbooks are shared. B) So I wrote some VBA code to download a copy to the Downloads folder like that: Dim RetVal As Long Dim SharePointFileURL As String Dim LocalDownloadPath As String Dim FileName As String RetVal = URLDownloadToFile(0, SharePointFileURL, LocalDownloadPath & FileName, 0, 0) If RetVal = 0 Then MsgBox "File successfully downloaded to: " & LocalDownloadPath & FileName, vbInformation This will message be replaced by the code we need to run... but for now I needed an indicator that it finished downloading. Else MsgBox "Failed to download the file. Please check the URL or your network connection.", vbExclamation End If So RetVal is = 0, and I do see the workbook in the \Downloads folder and it has a size of 4KB and the correct Date Modified time stamp, BUT When I try to open the workbook via the Excel desktop application I get the message: Excel cannot open the file "File name here" because the file format or file extension is not valid. Verify that the file is not corrupted and that the file extension matches the format of the file. The workbook should be 34KB in size and that 4KB file is not what I need??? Any ideas how to manage this, saving a workbook from a SharePoint / Teams file location to the computer so that we can run VBA code on it. GiGi
Autocompletar em vez de trazer dados acima da célula, traz os que estão abaixo.
Olá Tenho especificamente uma planilha que no Excel web (Microsoft 365) em que o autocompletar não está funcionando da forma normal, isto é, trazendo os dados que estão na mesma coluna, acima da célula. Em vez disso, traz os dados que estão abaixo. Exemplo: Ao digitar "b" em A5, em vez de o autocompletar sugerir "beta", traz "ball". Alguém tem esse problema? Conseguiu corrigir? Como?Autocomplete has stopped working
I'm using the Office 365 (web version) of Excel to keep track of my paper trades. Until recently, I was able to populate the ticker name and symbol columns with previous entries by just starting to type their name. It would then "autosuggest" based on those previous ticker names/columns. Now, it doesn't do it anymore. I've tried to find a solution online but they often reference menu items that don't even exist. How do I fix this? I can always copy and paste but it's so much easier and convenient to be able to use this auto complete feature to populate with pre-existing entries.
SUMIFS function won't give me a sum for 1 text criteria and date range
I have been trying to create a formula that will pull the sum of my various expenses/income according to the their category and within a month's range. Here is the formula I wrote: =SUMIFS('Transactions'!E:E,'Transactions'!C:C,'Gifts','Transactions'!A:A,'>='&'1'!G2,'Transactions'!A:A,'<='&'1'!H2) I want the sum to populate on the sheet named '1' and I'm having it pull the info from the sheet named 'Transactions,' which has a masterlist of all my transactions for the year (both income and expense) which includes the columns date, paymentmethod, type, description, and amount. I have data validated date, paymentmethod, type, and amount. Column E is amount, C is type (which includes 'Gifts'), and A is date. G2 and H2 are start date and end date which I typed out as 1/1/25 and 1/31/25. They are formatted as dates and data validated. Every time I press enter on this it just shows what I typed with red dotted lines around it. Other basic functions work (e.g. sum) but this one won't. Any idea how I can get this to work?
How to resolve formula discrepancy Excel/SharePoint
Good afternoon, could someone help me? The formula =IF(ISERROR(INDEX(Form1!F:F, ROW()-90)), "", IF(INDEX(Form1!F:F, ROW()-90) = "", "", INDEX(Form1!F:F, ROW()-90))) works in offline Excel, but in SharePoint/Excel Online it shows an error. It appears there is an error in the formula. I am using Portuguese in both versions.
Excel For Web: "Picture > Place In Cell" is Gone
Hi, I have Excel for the web. A few months ago, when I was using Excel for the web, the Insert > Pictures > Place In Cell option became no longer available on my Windows 11 laptop. I don't think it has anything to do with any new updates to Excel for the web, as I'm able to use Place In Cell on my iPhone (where none of my desktop images are stored). Here is a reference of what I'm trying to do: https://www.youtube.com/shorts/V0tX83Zm-kY?feature=share How can I update my excel for the web to return it to it's original settings, allowing me to use the place picture in cell feature?
