Hi all,
I have a code that another member kindly put together for me. It works on my desktop (Excel 2010) but when I log on via Citrix and open Excel 2003. When I refresh the pivot table the dates change to US format so instead of 07/12/2016, 08/12/2016 & 09/12/2016 it changes to 12/07/2016, 12/08/2016 & 12/09/2016.
Please Login or Register to view this content.
Is there was way to work around this?
Thanks in advance
Does formatting the column to show English UK Dates instead of English US Dates work?
*---EDIT---*
if it does then you can add this to the bottom of your sub
just replace the "K"'s with what ever column you need. If you would like it in the other format (ie: DAY/MONTH/YEAR) then use this format "d/m/yyyy"Please Login or Register to view this content.
Last edited by frabulator; 12-21-2016 at 10:28 AM.
I am afraid not, tried to format all cells that were affected but to no avail.
It's frustrating, it works beautifully on the desktop it's just through Citrix it doesn't!
The dates on the individual pivots tables are correct, it's just the summary data that is incorrect.
I suspect Citrix's session regional setting is what's causing this issue.
See link for how to set up Citrix.
https://support.citrix.com/article/CTX103288
Hi,
Tried changing the settings but they were all set to UK already. 'Changed' them and applied, logged off but still not working.
Also check Excel's language setting/format when accessing through Citrix, make sure it matching Windows.
Is there a way to do that other than from the Start Menu? There's no language settings option on the Microsoft Office Tools.
Hmm, you may be missing some components. Sorry, can't help you further as I don't have copy of Office/Excel 2003.
Thanks anyway. back to the drawing board for me, might be worth a call to my IT dept!
After the initial, turn it off and back on again instruction they may be helpful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks