Map Chart in Excel 365 does not identify himachal pradesh state in India
I am trying to build a series of heat maps for India providing some state level insights. When attempting to build a map chart, I realised that the chart doesnot identify Himachal Pradesh. Could someone please help me with this ? I used the following test data. States Number Puducherry 1 Lakshadweep 2 Andaman and Nicobar 3 West Bengal 4 Orissa 5 Bihar 6 Sikkim 7 Chhattisgarh 8 Tamil Nadu 9 Madhya Pradesh 10 Gujarat 11 Goa 12 Nagaland 13 Manipur 14 Arunachal Pradesh 15 Mizoram 16 Tripura 17 Daman and Diu 18 Delhi 19 Haryana 20 Chandigarh 21 Himachal Pradesh 22 Jammu and Kashmir 23 Kerala 24 Karnataka 25 Dadra and Nagar Haveli 26 Maharashtra 27 Assam 28 Andhra Pradesh 29 Meghalaya 30 Punjab 31 Rajasthan 32 Uttar Pradesh 33 Uttarakhand 34 Jharkhand 35 Telangana 36 I have added the file for reference too Thanks in advance :)
Excel hyperlink formula returns #VALUE! when opened in Teams but works when opened on desktop app
Hi, For some users (5 employees) a hyperlink formula shows as #VALUE! when they open the Excel spread sheet in Teams. It works if they open it in the desktop app. Is this a Teams or Excel issue? Is there a way to fix it so the hyperlink formula works for them in Teams? For 30 other users, the hyperlink works in Teams. 1. I can confirm that all 35 users have Office 365 installed 2. This is the formula: =IF(R5="Send email to FLM/2IC",HYPERLINK(CONCAT("C:\Users\",RIGHT(LEFT(INFO("DIRECTORY"),FIND("S",INFO("DIRECTORY"))+6),7),"\Company Name\TQA Tools\",'Lists - Do Not Delete'!$O$17,".oft"),"Template Email to FLM/2IC"),"") 3. The template to which the hyperlink leads is saved on each user's desktop therefore the formula part of "FIND("S",INFO("DIRECTORY"))+6),7),"\Company Name\TQA Tools\",'Lists - Do Not Delete'!$O$17,".oft")" is able to look up the user ID which starts with an "S" followed by six numbers 4. The only difference for the 5 users is that they synced their entire desktop to OneDrive at some point thus their directory folder path would not be the same as the other 30 users who never synced their desktops. But even after unsyncing, removing the folder path from OneDrive, they still get the #VALUE! error when opening the Excel spread sheet in Teams 5. They do not get the #VALUE! error when they open the spread sheet from the synced folder to which the synced spread sheet was downloaded 6. Each user has their private Teams channel from where the spread sheet is saved and synced I am not certain if it is a Teams issue or Excel issue but assistance to resolve the #VALUE! error when the 5 users access it via Teams will be helpful. Thank you in advance.
Embedding Excel into Website requires login
Hello All, I am attempting to embed a file into our website, and am running into issues. I found another post here that seems to talk about PPT but this trick did not work for me. https://techcommunity.microsoft.com/t5/sharepoint/embedding-ppt-requires-sharepoint-login/m-p/265418 Maybe Matt Coats will see this below and have some other idea 🙂 Also this Microsoft post tells me to do something that doesnt seem available to me: https://support.microsoft.com/en-us/office/embed-files-directly-into-your-website-or-blog-ed07dd52-8bdb-431d-96a5-cbe8a80b7418 I created a link to an excel file where anyone can view it: https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo This link works fine for anyone logged in or not logged in. But when I attempt to use this link as an embedded view it does not work without logging in <p></p> <div style="text-align: center;"> <p> <iframe width="1000" height="600" frameborder="0" scrolling="no" src="https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo&action=embedview&wdHideSheetTabs=True&wdHideHeaders=True&wdDownloadButton=False&ActiveCell=A2"></iframe> </p> </div> <p></p> here is a page it is embedded on: https://www.troutvalleyil.com/test.html I can access the excel file without any issues If I use my browser that is logged into O365 then the web page works But when anyone who is not logged into O365 attempts to access this web page it does not work for them Any thoughts / ideas / suggestions?
Copy visible cells only in 365?
The article says By default, Excel copies hidden or filtered cells in addition to visible cells. but when I copy filtered or hidden not included by default. Is there any setting for this in Excel 365? "If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only the summary data from an outlined worksheet." https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
Need help on excel
Hi All, Need help if any can. I have a formula, I need to adjust the formula with criteria if in cell F6 "AR" so result of1st date of an array must come with 1st day of the left side dated month and rest should be the end of the month (Note if cell F6 is with AR Only 1st date should come with 1st date of the month rest should be the end of the month), if not AR all should come with the end of the month date. i am really thankful Regads TariqTransform data in excel
Hi Recently, my client has shared raw data, which I have processed a bit (attached here for reference). The workbook has 2 sheets: 1. Raw Data 2. Converted Data I have data in the format provided in Raw Data sheet and want to get the data in format provided in Converted Data sheet. Is it possible in excel to get the data in the desired format
Userforms Excel MAc 365
Hola Amigos, necesito su ayuda... Soy desarrollador de aplicaciones en VBA Excel, tenia la licencia 2011 para mac, pero esta dejo de tener soporte, entonces adquirí el 365, sin embargo en esta versión en VBA no se pueden editar o insertar Userforms, a pesar de que si se ejecutan lo Userforms creados previamente. Gracias Hello Friends, I need your help ... I am an application developer in VBA Excel, I had the 2011 license for mac, but I am no longer supported, so I acquired 365, however in this version in VBA you cannot edit or insert Userforms , although if previously created Userforms are executed. Thank youExcel performance improvements now take seconds running Aggregation functions
I’m excited to announce that faster Aggregation and RealTimeData functions are available in the latest M365 Monthly and Semi-annual preview channels! This is our next wave of Excel M365 performance improvements after Speedy Lookups to reinforce our commitment to making Excel M365 the new gold standard of Excel Performance. This time around we have even more improvements, starting with...
Linked Excel Files in Sharepoint don't work when links update.
I have two excel files with links to each other, both saved in the same folder in OneDrive. Here is an excerpt of one of the formulas when I first created the links: ...SEARCH("IVC",INDEX('[Live Pipeline (v2.00).xlsm]Project View'!$A$1:$FZ$50... However after closing and opening the file, they all changed automatically to: SEARCH("IVC",INDEX('https://MYORG.sharepoint.com/Shared Documents/Sales/[Live Pipeline (v2.00).xlsm]Project View'!$A$1:$FZ$50 and changed so the value they return is #VALUE If I do a Find/Replace on https://MYORG.sharepoint.com/Shared Documents/Sales/ to remove it from all formulas, everything starts working again. I have read that this could possibly be solved by unchecking the "update links to other documents" box, however next time I open the document, the box is back ticked. Any ideas to what I'm doing wrong?
