LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bobak
 
Posts: n/a
Default prompt user to change source of links

I have an Excel based reporting pack that is linked to an Excel file
containing the data for my reports. The name of the Excel data file is
changed at least twice a week and saved as a new version with a date suffix.

When i open my report file I want make the user select the most recent
version of the data file by changing links to this file and updating them. Is
there a way to do this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 1 January 21st 05 03:17 PM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 0 January 21st 05 02:57 PM
how do you change pathways (links) when consolidating spreadsheet. confused Excel Discussion (Misc queries) 0 December 9th 04 01:47 PM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 10:12 PM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 09:27 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"