Questions

5 answers

Excel (Office 365, Mac) not saving UTF-8 CSV files properly with \n line endings?

With apologies if this has been addressed elsewhere... This was working for me just fine until recently. Now, when I save files as UTF-8 CSV files, it saves them with "\r" line endings. This is really fouling me up! Any ideas? Thanks in…

asked

Anonymous

0 answers

Drobox to SharePoint

I have been using Dropbox from a long time and it’s been great and now my company is forcing us to use SharePoint/OneDrive. Is there a way to transfer all my documents from Dropbox to Sharepoint? What is the difference between Sharepoint and One Drive?…

asked

Anonymous

1 answer

Adding color in column validation

I've created a custom list in SharePoint online to track our department training. I have a date and time column titled "Expiration" that will list the date that the training/certification will expire. I would like to add a formula to this…

asked

Anonymous

1 answer

Power Query Blocking issues

Hi, I'm facing a blocking issue, no way for me to escape. I'm about to migrate to a new pc, so i can put in place all necessary steps to go ahead, with no results. The new pc is running Windows 10 Pro, release 1909 (18363.815). Office 365 family Excel…

asked

Anonymous

3 answers

Can't move folders that contain items to a different SharePoint library

Hi, So I am having issues when trying to move a folder from one SP library to another on the same site. This issue only occurs when the folder contains items. The error I receive is "You have to delete all the items in this folder before you can…

asked

Anonymous

3 answers

equation editor: minus sign in a sum causes a small problem

I have a Latex expression involving a sum with a minus sign in it: \sum_{s=-\infty}^{\infty} - a_{s} \left(2 s + 1\right) \sin{\left(\tau \left(2 s + 1\right) \right)} Inserting into the equation editor leads to an incorrect result. I have a test program…

asked

Anonymous

3 answers

Can we apply formatting to Top Bar(List Title area) of List View using Column formatting

Hi Can we apply custom formatting on the top bar of the list view where List title is coming using Column Formatting. If not then what are other ways to achieve that as we have a requirement where we need to display that area with different color and…

asked

Anonymous

2 answers

VBA Can I prepare a WHERE clause for a SQL query from one of the excel columns? > YES

Hello there, I have a sheet extracted by the VBA code. I would like to take the column which has order# and remove duplicates in that and then use it in my SQL query string as WHERE clause predicate. Is there any idea how can I extract this into where…

asked

Anonymous

1 answer

Microsoft account email on iPad is the wrong email to login. But no link to change the email is offered.

Word on iPad asks me to login to Microsoft but it shows the WRONG email and no way to change the email! My account at Microsoft doesn't use the email shown. Why isn't there a link to change the email? It shows an email address (the wrong one) and only …

asked

Anonymous

4 answers

Horizontal scrolling in Excel on a Mac - Can it be disabled?

When using my trackpad to scroll vertically in Excel (on a Mac), the scroll bar pulls to the right and I lose my left side columns. Very annoying while working with large spreadsheets when I have to continuously readjust my view to see my work on the…

asked

Anonymous

2 answers

MSCAL.OCX

Hi, I`m using a acces program and when I open it, it always " searching for referenced files: MSCAL.OCX. How can I get rid of that? Thanks!

asked

Anonymous

1 answer

Autocorrect superscript at the beginning of a word

For my work I often have to type in words with superscripts at the beginning, such as 13CO2, where the 13 is supposed to be superscripted and the 2 is supposed to be subscripted. Tired of doing this ~20 times per document, I tried creating an…

asked

Anonymous

7 answers

365 excel application.inputbox problems on win 10

winin: lnWinsDue = Application.InputBox("Please enter winnings for " & WinArray(lnArrayRow, 2), _ Type:=1, Title:=gcMsgTitle, Default:=0) Select Case lnWinsDue …

asked

Anonymous

1 answer

Trying to cancel Subscription but don't have the email account of the initial purchase - Still being charged

Trying to cancel Subscription but cannot identify the work email used for the initial purchase. I have an order number from the first payment made last year, but doesn't seem to help. How do I cancel the sub. so I am not charged on a work card?

asked

Anonymous

1 answer

Powerpoint with online video link - message constantly pops up

i'm using office 365 business on MacOS and iOS. i've inserted video link (youtube) into my presentation. it runs ok, but throughout the presentation there is constantly the message pops up asking "enable media or block media". where is the…

asked

Anonymous

2 answers

Alerts for shared mailboxes

Hi Team, Please I would like to know how to create office 365 alerts or notifications when emails are received in a shared mailbox. Any suggestions would be greatly appreciated. Thank you

asked

Anonymous

3 answers

Excel data clean up

I am needing to clean up some data in Excel. I have a source that provides unnecessary information around the data that I actually need (which varies in length as it contains names) and I would like an easy way to remove that unnecessary information…

asked

Anonymous

2 answers

Finding the Folder Path for a file

I am trying to build a function that would return the folder path given the filepath. I.e., Function folderPath (filePath as string) as string End function If filePath is: "C:\Users\Owner\Downloads\SMR_HW_Delivery on…

asked

Anonymous

4 answers

My custom theme is not loading for other Powerpoints (PowerPoint 365 for Mac)

I’ve built a custom theme, saved it, and tested the theme by opening up a new Powerpoint and applying the theme and it seems to work fine. I’ve seen the .thmx file, but when i make modifications to the theme and save/replace file it seems to disappear …

asked

Anonymous

0 answers

Excel Macros Questionaire

Hello, I'm trying to make a questionnaire using Excel Macros (xlsm file) and I'm having trouble making the last sheet. I'll try to explain what I'm trying to do the best I can. For this questionnaire, when the user answers all the questions (1 question…

asked

Anonymous

Filter

Content

1,811,518 questions

Excel (Office 365, Mac) not saving UTF-8 CSV files properly with \n line endings?

Drobox to SharePoint

Adding color in column validation

Power Query Blocking issues

Can't move folders that contain items to a different SharePoint library

equation editor: minus sign in a sum causes a small problem

Can we apply formatting to Top Bar(List Title area) of List View using Column formatting

VBA Can I prepare a WHERE clause for a SQL query from one of the excel columns? > YES

Microsoft account email on iPad is the wrong email to login. But no link to change the email is offered.

Horizontal scrolling in Excel on a Mac - Can it be disabled?

MSCAL.OCX

Autocorrect superscript at the beginning of a word

365 excel application.inputbox problems on win 10

Trying to cancel Subscription but don't have the email account of the initial purchase - Still being charged

Powerpoint with online video link - message constantly pops up

Alerts for shared mailboxes

Excel data clean up

Finding the Folder Path for a file

My custom theme is not loading for other Powerpoints (PowerPoint 365 for Mac)

Excel Macros Questionaire