Referencing data in my formulas from specific file names in SharePoint.
We have a company SharePoint site with multiple subfolders each containing monthly excel spreadsheets. In one of the folders, I have my master spreadsheet that where the formulas are pulling in data from the files that are being uploaded. This works when I open my master spreadsheet and one of the monthly sheets, (e.g., East-February, or West-January and then link the two cells with an = and click on the source cell. On my Master spreadsheet the formula looks something like this: ='[West-February.26.xlsb]MontlyBudget'!A1 There are about 17 different folders however and instead of opening each one and redoing this every time one in uploaded. I would rather just copy the formula on my master spreadsheet i.e. ='[East-February.26.xlsb]MontlyBudget'!A1 ='[North-February.26.xlsb]MontlyBudget'!A1 ='[South-February.26.xlsb]MontlyBudget'!A1 etc. Ideally when the North area uploads their spreadsheet the formula just pulls in that data. What is happening is that I am copying the exact formula over to my new cell, I end up with a #REF error message and cannot seem link. 2 questions: Can I link these without opening up each spreadsheet separately and copying and pasting the link each time? Can I link these to future files that aren't yet created, e.g., Once West-December.26xlsb is uploaded, the data automatically pulls in?
Attachement date of outlook classic
when i download the attachment from old email, the date of the file, should be today date, but that doesn't happen, it appears the old date of when it was created. In a big folder of downloads i cant find it. This happens in outlook 365, outlook 2016 and Outlook 2024 classic with email 365 account. But in Outlook 2019 classic works perfectly it sava with today date. Should be some configuration?Onedrive file sync issue
I just recently had an issue where my files were not synced because i had run out of onedrive storage space so i just got rid of a bunch of unnecessary files sitting around which freed up a ton of space. The files still werent synced so i resett one drive to sync them back up but when i did that it just restored the files i had just deleted. I kept trying over and over again but the same kept happening and now i cant sycn my files. Ive tried everything, restarted my computer. Reinstalled onedrive but its all not working and my files and folders wonf sync. What do i do to fix this?
VBE The XLSM file can't save macros
Two computers: On my personal computer, the VBE module shows 'no open projects,' most of the buttons are greyed out, and if I try to click any non-greyed button, it gives an 'error in loading DLL.' On my work computer, the issue is: after creating a new XLSX document and saving it as an XLSM file, it opens fine; however, once I insert a Macro, it shows that the file is corrupted, and repairing it deletes my macro. I’ve tried reinstalling, adding trusted folders, modifying the registry, and rolling back to version 2607, but nothing worked. The personal computer is set to the US region and I downloaded the English version of 365, while the work computer is set to CN and I downloaded the Simplified Chinese version of 365. Also, the USER folder on my personal computer was moved to the D drive. I contacted Microsoft support, and the staff suggested I post in this community .
New Outlook: "Changing the ImapRemoteServerInfo is not allowed" after host migration
Hi everyone! I've migrated my domain/mailbox from one IMAP host to another in May. It cannot be added to New Outlook for Windows — fails instantly with INVALID_CREDENTIALS INTERACTION_REQUIRED, even when I deliberately enter a wrong password (so it's failing before authentication is even attempted). Using DevTools (olk.exe -devtools), the Network tab shows the real rejection from Microsoft's backend: Changing the ImapRemoteServerInfo is not allowed. Attempted to change it from imap.olddomain.sk to imap.newdomain.sk So New Outlook has a cloud-mailbox / connected-account shadow record for this address, pinned to the old host from a previous add attempt, and the backend refuses to update it. What I've confirmed: Webmail and a second mailbox on the same domain/host both work fine → not credentials, not the host. The account does not appear in Settings → Accounts (so I can't use "Remove from all devices" which worked on my first account). It's on no other device or client. App reset didn't help (record is server-side, not local). It's been ~7 weeks, so any 30-day inactivity purge hasn't cleared it How do I get this stuck cloud-mailbox / connected-account record purged when it isn't attached to any removable account? Is there a way to force it, or does this need Microsoft backend action?
Excel Insert Copied Cells Creates Blank Row
Whenever I try to copy row 2 below, right mouse click, and select Insert Copie Cells, I incorrectly get a blank row. This is in Excel safe mode with all add-ins disabled. Does anyone know how to fix this? See sample data below. Thanks. 1 32134 234234 45645 456 456 456 536 4567 456 456 456 456 456 456
