office

Hello everyone, I have a workbook that I built in Excel 2013 which contains some VBA code requiring programmatic access. I sent the sheet to a user who has Office 365 along with instructions to allow programmatic access that I found at...

I know what the FUNCRESS.XLAM sheet does, I have used it for a long time. In the past when opening an xlsm workbook only the workbook opened. Recently with no changes by me, a second window for FUNCRES.XLAM opens. This is true for existing and new workbooks. If I close it the entire workbook...

I have been experiencing a problem with Excel, although before posting here about it, I thought I'd update my version of MS Office. I configured Windows (Windows 10, Office 2016) to update all MS products, not just windows. But still, my version of Excel is v.1812, which is dated to November...

i have been requested to make a simple absence viewer iin our office that is feeding from a report from our HR system and appending that report over the top of the previous one. Essentially, the report comes down like this : Name, Unique ID, Office Location, Dept and then absent date. At...

Hello, We have recently installed 64-bit excel for Office 365, and it seems to be very slow in response time / stickiness in cells. Anyone know what might be causing this? thanks

Hello, Would you know when would all Excel, Office 365 users will be able to utilize the following formula: "XLOOKUP"

Hi I have written a vba code in excel 2010. After optimising , it is taking 1min 20 seconds to run in excel 2010. But when I am running the same code in office 365, it is takign more than 3 minutes to run(although a much faster machine). Is there any resolution to this problem?

We have an issue with the excel where there is noticeable alow down in the newer version of office.When getting an excel handle create dispatch and open api of Microsoft office takes more time in office 2016 then in office 2013.Pls guide me with the possible solution or reason for thjs slowness.

I'm away from my office traveling, and trying to get some work done. Unfortunately, every time I open Excel I immediately get an error box that pops up saying, "There was a problem connecting to the server xxx," with xxx being the name of a server I sometimes connect to when I'm in the office to...

Hi, I need a formula which can pop up late if the individual has log in to system beyond 9:40 am, but if the person has left office at 9:00 pm , then he will get grace of 1:30 hour next day i.e he can reach office by 11:00 am next day but if he comes beyond 11:00 then he is late. Date...

Hi all, I have failed in trying to find this information via searches on this forum and Google so here are my questions. Using VBA MS Office 2011 for Mac: Can you hide the title bar? Is it possible to get a picture to be inserted into a userform? No matter what size or format I try I keep...

Hi guys, need help on ADO SQL code for accessing Excel Data (using Excel version 2013) i have data like this in picture https://drive.google.com/open?id=1QGWO4fmCx8wYR-U1vkKEJq5xfDgPDSJS what i need is shops in every office that have highest sum(credit) in each TOP the yellow colour is the...

Hey all, I am seeking some general advice from all those that have gone before me. I work in a small office with REALLY slow computers. I am working on a log that tracks work flow in the office. All should be able to see the current data and all should be able to update it as they complete...

I have Office 365. Whenever I start Excel or open a new file with Excel, it opens (or goes to) full screen mode. I can find no way to stop this from happening. Any ideas?

Power Bi is not displaying content from the office planner.Our requirement is to office planner content in Power Bi Page.We are using tile with link set to office planner however we end up with error message "Content cant be displayed in iframe".Is therr any other method for dislaying the...

Hello, i am receiving a error message while copy data from one excel sheet to another excel sheet. this error is same when i copy data 2-3 blank rows or 2-3 blank cells. Below is error message "The Picture is too large and will be truncted." i tried many options to close this error like i...

so let's try this again. I'm trying to get a specific drop down list when a specific category of expenses is chosen. in cell F13 I have a drop down list with Office, Exec and Conf/Mtg What I would like to achieve here is that in cell I13 a drop down menu will populate according to what the...

Hi Guys I have maintenance old macro, this macro work in WinXP 32bit & Office 2010 but now user need to upgrade computer into Win10 x64 & Office 365 there are a problem when accessing this code data_path = Left(ThisWorkbook.Path, 31) cn_bank.Open "driver={Microsoft dBase Driver...

Hi Folks! I am back asking for your help. I receive a file in the following format. The rows that start with data in Column "A" are part numbers. Below those part numbers with data beginning starting in column "C" are accessory codes and accessory descriptions, pertaining to the part above. I...

Does any one know if MS Query within excel will work in office 365? Regards, Odsmih