AndrewMullins
New Member
- Joined
- Jan 29, 2017
- Messages
- 3
Folks,
I've researched till I'm blue in the face...literally. This is my last hope so I thought I would stop here. I've snooped around in these forums for awhile but never really posted. Thought maybe you all could help a brother out.
My excel seems fairly unstable, it crashes almost daily and I've learned that the cmd+s get's used more than any other quick key now. I'm not sure what to do.
I'm running every single update to both Office and the Mac and I still have issues with it.
The most repeatable crash that I can get to occur almost every time is running a "Text to Column" on about 300 cells in a column. This occurs with both the delimited function and fixed width. Being in property management, I have to pull constant reports from Yardi. Most all of the reports are 97-2004.xls, and the Text to Column is crucially important as I need to convert entire columns from text to number/accounting. Also, I need to remove strip/split certain cells. For instance, I need to split "5901.0000 Depreciation" into two separate cells for sorting purposes. Again, crucially important.
I'll post my hardware/software specs below. If you any of you have any ideas, please let me know. #frustrated
Thanks all,
SOFTWARE:
1. EXCEL:
Microsoft Excel for Mac 2016
Version 15.31 (170208)
Office 365 Retail License
2. Macbook OS/Software:
System Version: macOS 10.12.3 (16D32)
Kernel Version: Darwin 16.4.0
Boot Volume: Macintosh HD
Boot Mode: Normal
Computer Name: Andrew Mullins MacBook Pro
User Name: Andrew Mullins (andyrmullins)
Secure Virtual Memory: Enabled
System Integrity Protection: Enabled
Time since boot: 19:55
HARDWARE:
1. PROCESSING:
Model Identifier: MacBookPro12,1 (2015)
Processor Name: Intel Core i7 (Broadwell)
Processor Speed: 3.1 GHz
Number of Processors: 1
Total Number of Cores: 2
L2 Cache (per Core): 256 KB
L3 Cache: 4 MB
Memory: 16 GB
Boot ROM Version: MBP121.0167.B21
2. GRAPHICS:
Chipset Model: Intel Iris Graphics 6100
Type: GPU
Bus: Built-In
VRAM (Dynamic, Max): 1536 MB
Vendor: Intel (0x8086)
Device ID: 0x162b
Revision ID: 0x0009
3. STORAGE:
Device Name: APPLE SSD SM0512G (This is a 512gb SSD and it’s fast)
Media Name: APPLE SSD SM0512G Media
Size: 499.42 GB (499,418,034,176 bytes)
Medium Type: SSD
Protocol: PCI
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 140.5px; text-indent: -140.6px; font: 11.0px 'Helvetica Neue'}span.Apple-tab-span {white-space
re}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 134.2px; text-indent: -134.2px; font: 11.0px 'Helvetica Neue'}span.Apple-tab-span {white-spacere}</style>
I've researched till I'm blue in the face...literally. This is my last hope so I thought I would stop here. I've snooped around in these forums for awhile but never really posted. Thought maybe you all could help a brother out.
My excel seems fairly unstable, it crashes almost daily and I've learned that the cmd+s get's used more than any other quick key now. I'm not sure what to do.
I'm running every single update to both Office and the Mac and I still have issues with it.
The most repeatable crash that I can get to occur almost every time is running a "Text to Column" on about 300 cells in a column. This occurs with both the delimited function and fixed width. Being in property management, I have to pull constant reports from Yardi. Most all of the reports are 97-2004.xls, and the Text to Column is crucially important as I need to convert entire columns from text to number/accounting. Also, I need to remove strip/split certain cells. For instance, I need to split "5901.0000 Depreciation" into two separate cells for sorting purposes. Again, crucially important.
I'll post my hardware/software specs below. If you any of you have any ideas, please let me know. #frustrated
Thanks all,
SOFTWARE:
1. EXCEL:
Microsoft Excel for Mac 2016
Version 15.31 (170208)
Office 365 Retail License
2. Macbook OS/Software:
System Version: macOS 10.12.3 (16D32)
Kernel Version: Darwin 16.4.0
Boot Volume: Macintosh HD
Boot Mode: Normal
Computer Name: Andrew Mullins MacBook Pro
User Name: Andrew Mullins (andyrmullins)
Secure Virtual Memory: Enabled
System Integrity Protection: Enabled
Time since boot: 19:55
HARDWARE:
1. PROCESSING:
Model Identifier: MacBookPro12,1 (2015)
Processor Name: Intel Core i7 (Broadwell)
Processor Speed: 3.1 GHz
Number of Processors: 1
Total Number of Cores: 2
L2 Cache (per Core): 256 KB
L3 Cache: 4 MB
Memory: 16 GB
Boot ROM Version: MBP121.0167.B21
2. GRAPHICS:
Chipset Model: Intel Iris Graphics 6100
Type: GPU
Bus: Built-In
VRAM (Dynamic, Max): 1536 MB
Vendor: Intel (0x8086)
Device ID: 0x162b
Revision ID: 0x0009
3. STORAGE:
Device Name: APPLE SSD SM0512G (This is a 512gb SSD and it’s fast)
Media Name: APPLE SSD SM0512G Media
Size: 499.42 GB (499,418,034,176 bytes)
Medium Type: SSD
Protocol: PCI
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 140.5px; text-indent: -140.6px; font: 11.0px 'Helvetica Neue'}span.Apple-tab-span {white-space
re}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 134.2px; text-indent: -134.2px; font: 11.0px 'Helvetica Neue'}span.Apple-tab-span {white-spacere}</style>
