Forum Discussion
downloaded worksheet file's formatting changes when saved/ copied to a workbook
So, I'm downloading a file which is automatically created from our data online, it downloads as a 'Microsoft excel worksheet'
I then have a simple VBS which compiles all the individual worksheets together into one workbook.
after this, the formatting changes for some small squares I have in the documents.
Before:
After:
if it means anything, the colours available in the fill change too?
I have tried creating a new document and adding the individual files, and it is fine, its just on the merge file it does this
Something about the format of the template I have that compiles the individual files changes, and I cant work out why.. any ideas?
Is it because it starts as a template, or because its a macro enabled workbook or something else?
Hello,
When you merge sheets into a master workbook - especially via VBA or VBS scripts - the destination workbook may use a different theme or color palette than the source files. That causes fill colors and formatting (especially "small squares") to shift or render differently. A similar issue was discussed on the Microsoft forum, where the accepted solution was to align the theme before merging:
- Copy using “Keep Source Formatting” when pasting or
- Set the workbook’s theme to an older version, such as Office 2007–2010, before copying, to preserve consistent colors
Did you consider using Power Query to merge worksheets? It can eliminate most formatting issues, especially those related to themes, palettes, and visual styles. Let me know if you need more information about Power Query.
Best regards,
Branka Kajiš, MCT
1 Reply
Hello,
When you merge sheets into a master workbook - especially via VBA or VBS scripts - the destination workbook may use a different theme or color palette than the source files. That causes fill colors and formatting (especially "small squares") to shift or render differently. A similar issue was discussed on the Microsoft forum, where the accepted solution was to align the theme before merging:
- Copy using “Keep Source Formatting” when pasting or
- Set the workbook’s theme to an older version, such as Office 2007–2010, before copying, to preserve consistent colors
Did you consider using Power Query to merge worksheets? It can eliminate most formatting issues, especially those related to themes, palettes, and visual styles. Let me know if you need more information about Power Query.
Best regards,
Branka Kajiš, MCT