Once the drive is formatted it will be compatible to be read and written to on both a Mac and PC, and the resulting FAT file system is compatible with all versions of Mac OS X, Windows 95, 98, Windows XP, Vista, 7, Windows 8, even Windows 10, it’s one of the most widely recognized and usable file system formats. To share a USB drive between a Mac and a Windows PC, there are two disk formats to choose from: exFAT and FAT32. The other formats -- Microsoft's NTFS and Apple's Mac OS Extended -- don't work well on the other operating system. Go to This PC, under 'Devices and drives', highlight the disk that represents your USB flash drive, right click and select Properties. In the new Properties window, check General > File system and you'll see what type of file system your flash drive is currently with. Assuming Vista or 7 (this should work on XP, 8, 8.1, and 10, as well) and that the disk is not showing up under My Computer at all: Connect your disk. Run cmd as an Administrator. Run diskpart.exe. If you need help in this program. List disk; Find the disk that corresponds to your USB disk. Select disk n where n is the number of the disk. My usb drive is formatted for mac how to format it for pc. I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and needs to close' when I try to save. I have tried copy/pasting the worksheet to a new workbook under a new name, I have tried deleting large chunks of it. I am no where near the information limit in terms of rows and columns. This document stops at Column I and Row 4500. There are no Vlookup links to other pages or other workbooks. It is very simple, and the only 'special features' or functions I am using are the SUM function and freeze panes on the first two rows. I need to be able to work on this file AND save it. Also, I am using Excel 97. Software/Hardware used: Excel 97, Windows XP (32 bit). I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. =========== Your MS Office application particularly MS Excel has probably encountered corrupted files or data. This corruption could have many reasons and the best thing you can do is to reinstall your copy of MS Office software and try using MS Excel again and see if it would work. I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. Excel for Mac version 15.29.1 crashes when closing documents or program. I see no correlation with specific documents or document type. Using Mac version 10.12.2 on an iMac. =========== Your MS Office application particularly MS Excel has probably encountered corrupted files or data. This corruption could have many reasons and the best thing you can do is to reinstall your copy of MS Office software and try using MS Excel again and see if it would work. Please enter an answer. Send me notifications when members answer or reply to this question. @ Labnuke99: Thank you, but I have tried copy/pasting in small chunks and large chunks. The problem continues. I do know which worksheet tab it is, though. ![]() I just need a way to debug it. If it helps, the only formula I use on that sheet is the Auto SUM button on the toolbar (meaning I don't actually type it out.) A current formula is =SUM(A29:A35) Then if I insert three rows at A31, it normally updates the sum and range to include the new rows. However, it broke all of a sudden. Is it possible that too many inserts into the SUM range will break it? That seems to be the only thing that doesn't work. I can enter data normally and it will save just fine. The problem only arises when I insert (or delete) a row or column. Thanks -ATCPurdue. Your Excel related problem intrigued me – I tried many different ways but can not break the system. The Auto Sum works very nicely and this option has been from many earlier versions of Excel. You can add many rows (or delete many rows) after defining the Formula. Of course the system will automatically adjust the new rows. For example: Your data in cols C29 thru C35. On C40 you have =SUM(C29:C35).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |