Hi there,

I know its probaly a common question however I need help with formatting my pivot table.

I have set up my lines/fills/font and accounting but when I refresh it dosnt stay. I have the Preserve cell formatting on update clicked on but it still changes.

Please help - its for an invoice and needs to look tidy.