Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2017, 01:37 AM
chuxnz chuxnz is offline Excel formatting issues Windows 10 Excel formatting issues Office 2016
Novice
Excel formatting issues
 
Join Date: May 2017
Posts: 2
chuxnz is on a distinguished road
Default Excel formatting issues

I have an excel workbook with several sheets.


Most have heavy formatting and formula.
The main sheet has rows with names and numbers in on column and amounts in the other columns.

The text in the names and numbers column is formatted to bold. This resets to normal text every so often.
Other sheets and colums are not affected?

Can anyonew advise the cause?

thanks
Reply With Quote
  #2  
Old 05-21-2017, 06:06 AM
jeffreybrown jeffreybrown is offline Excel formatting issues Windows Vista Excel formatting issues Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Seems like only two things could cause something to change all of a sudden...

1) Conditional Formatting
  • Select the entire sheet and Data >> Data Tools >> Data Validation
  • Is anything there? If there is, it would mostly likely be based off of some type of trigger.

2) VBA
  • Same with VBA. Something has to act as a trigger to fire the code (if there is any)
  • Select Alt + F11 and look through all of the modules to see if any code exist in your workbook.

http://www.rondebruin.nl/win/code.htm
Reply With Quote
  #3  
Old 05-21-2017, 01:25 PM
chuxnz chuxnz is offline Excel formatting issues Windows 10 Excel formatting issues Office 2016
Novice
Excel formatting issues
 
Join Date: May 2017
Posts: 2
chuxnz is on a distinguished road
Default

Thanks
Could'nt find anytrhing.
Have reverted from macro enabled xlsm to xlsx.
So far so good.

Ta
Reply With Quote
  #4  
Old 05-21-2017, 01:34 PM
jeffreybrown jeffreybrown is offline Excel formatting issues Windows Vista Excel formatting issues Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Good news!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting issues OLq Project 0 05-16-2017 12:22 PM
Formatting issues when updating linked Excel charts Becky808 Word 0 08-05-2015 03:38 AM
Excel formatting issues Picture Formatting Issues mayj Word 1 04-02-2013 03:09 AM
Advanced formatting issues may24 Word 2 04-21-2010 01:39 PM
Having some formatting issues after converting PDF to .doc amf25 Word 1 06-05-2009 02:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft