excel

  1. Kaiz1000R

    How to Email MS Excel Spreadsheet directly itself?

    There's sharing as email attachment option on excel, I have connected my Gmail to the windows mail by Mail in the control panel. But when I share an Excel file via email it didn't send. Any solution for this?
  2. C

    Excel seperate data into a Matrix

    Im looking to transform data output into a matrix. The data - continous table: Date Names Topics 1/1/01 Tom;Dick;Harry topic1;topic2;topic3 7/1/01 Dick;Harry topic1;topic4 The matrix required: Topic1 Topic2...
  3. Liber8ed1

    Huawei M5lite - can't delete excel file

    Hi! :) I'm using a Huawei Mediapad M5 lite and I'm unable to delete an excel file that was saved to the device. I can see the file using the File option in Excel, but when I try deleting it I get a "Not Allowed You don't have permission to delete this file" message. (it is a read only file)...
  4. C

    Excel & SharePoint

    Hi, thanks for looking. I need a way to search a workbook and replace the character "\" with "/" a normal search and replace isnt working for some reason. Reason behind it: i want to house interlinked workbooks on the sharepoint. links to documents in the same or sub folders migrate just fine...
  5. LUIS39

    Excel freezing constantly

    Tech Support Guy System Info Utility version 1.0.0.9 OS Version: Microsoft Windows 10 Pro, 64 bit, Build 18363, Installed 20190620212503.000000-480 Processor: Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7, CPU Count: 4 Total Physical RAM: 8 GB Graphics Card...
  6. S

    How to fire an Excel macro from MSAccess?

    I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the...
  7. M

    Excel: Move object on chart-it returns to original position

    I am using a mac, Excel 2016 (not sure which version). I have multiple graphs and have added text boxes and lines/arrows to chart. When I try to move one of these text boxes or lines, it bounces back to the original position. These are not grouped. This is happening to some users in my office...
  8. T

    Word and Excel “not responding” when using laptop remotely

    Hello- I have a recurring issue that when I work remote using my HP laptop (remoted in to my office network or not). Every time I work in excel or word these files will become unresponsive. They are not large files. I have also tried working off my desktop and not remote in to the network, but...
  9. A

    How to convert Excel into GPX

    Hello, I have almost 500 lat and long coordinates in an excel sheet that I need converted from their current state (excel) into gpx so I can load into a marine GPS. Does anyone know how to convert these or a program that can assist me? I cant imagine spending 3 days manually entering them...
  10. Y

    support required in VBA code

    Team... I’m new to this tech support web... I have zero knowledge on VBA, can someone help me out... I need to automate the attached excel and to send reminder email to colleagues when the due date met. New column will be added frequently before the next due column (currently “AK”)...
  11. B

    MS Word copy-paste problem

    Hi guys! My problem is that I can't paste anything to ms word, not a text or a picture from the clipboard. If I press ctrl+v a symbol appears from a new font what I installed earlier and used. I tried to reinstall but it didnt worked. The copy-paste command works in excel and in other programs...
  12. B

    Excel Page Numbering (no, not the way you are thinking)

    Mornin' all.... Before we begin, I truly know all about page numbering in Excel. So I do not need any instructions about the usual way to do it. Got that down, 100%. Been doing it correctly for years. At my job I do statistical data modeling. I end up writing a memo for the non-math people...
  13. R

    Creating Email Reminders From Excel

    Hi, I have created a workbook that tracks individuals qualifications that shows me those who need to renew in 90,60,30 days. I can toggle between the 3 or set different parameters if needed. Instead of copying and pasting those details into an email i would like to be able to auto copy to...
  14. F

    Excel Xlstart folder

    Hi All, looking for help on an issue I'm having with the personal.XLSB workbook, I'll be as clear as I can. Long time users of Macros stored in an excel workbook saved in C ://users/username/appdata/roaming/microsoft/excel/xlstart Stating the obvious this workbook should open hidden but make...
  15. E

    Excel - Transposing Daily Dates into a Weekly Schedule

    Hi All, I have plotted dates manually on a daily calendar in Excel. Top two rows have the day and weeks (wk 1,wk 2,wk 3...) Second calendar is by week - WE date and weeks (wk1, wk2, wk3...) Commonality is the weeks. Q1. Can I automate the manual dates input if it's multiple date in a row...
  16. V

    How to convert a TIF file with text to Excel file on a MAC?

    I have a TIF file image with some text in a table that I need to make into an Excel (or Word) i.e. text must be able to be edited so it can't just be an image in Excel or Word. I am using a MAC. I don't want to type everything into Excel or Word. I need to have this done in the next couple days...
  17. D

    Solved Increment date by weeks accounting for 5 week months

    I'm creating a list of dates by week, the first week of the year will be input manually and the rest of the year will automatically populate. Since there are 4 months that have 5 weeks I need to show 5 rows per month. I can get it to leave the 5th week blank on the first 4 week month, but I...
  18. L

    Solved SUMIFS help

    I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2)...
  19. I

    All my files are opened as excel instead of word

    So when i open any file like a PDF or something, it's automatically opened as an excel document when i want it to be word. I've already tried setting word as a default app but it still doesn't work. Also, i tried going to the downloaded files and pressed 'open documents like this with word from...
  20. S

    Display Excel sheet in SharePoint 2016

    What options are there to be able to display an Excel sheet on a SharePoint 2016 page if Office Online Server is not installed? Are there any workarounds that I can use (e.g. would an iFrame work?) as an interim step? I hope to get OOS at some point, but would like to offer users something in...
Top